How to change the ownership of a schema in ms sql server?

0 Answers  

---

If you are working on a SQL database and if suddenly a developer changes the code and your queries results start giving errors,how will you check using a T-SQL query (on system tables) that what has changed in the database.

2 Answers   Microsoft,

---

What is a field name?

0 Answers  

---

What are the characteristics of modern DBMS?

0 Answers   Ericsson,

---

Mention the differences between having and where clause.

0 Answers  

---

What is index, cluster index and nonclustered index?

0 Answers  

---

How to delete duplicate rows?

0 Answers  

---

What is difference between temp table and cte?

0 Answers  

---

how many non clustered index in sql server 2008,2010,2012

2 Answers   Accenture,

---

How to create new table with "create table" statements?

0 Answers  

---

How can I tell if sql server is 32 or 64 bit?

0 Answers  

---

1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?

0 Answers  

---