Answer Posted / vani

version 6.5 in 1995
version 7.0 in 1999
version sql 2000 in 2000
version sql2005 in nov 2005
verson 2008 in Q3 2008

What is the difference between the export /import functions in sql studio and standalone sql manager? : sql server management studio

1092

---

Explain syntax for dropping triggers?

901

---

What is impersonation? What are the different impersonation options available in ssas? : sql server analysis services, ssas

941

---

How many databases instances are there in sql server 2000?

1053

---

Can a table be created inside a trigger?

938

---

Explain what are the basic functions for master, msdb, model, tempdb databases?

933

---

Is it possible to update the views? If yes, how, if not, why?

985

---

what is difference between view and Dip.

2386

---

How to recompile stored procedure at run time?

1031

---

What is blocking and how would you troubleshoot it? : sql server database administration

1007

---

What is coalesce in sql server?

1018

---

What is normalization of database? What are its benefits?

985

---

What is a full text index?

889

---

What is system stored procedures?

1000

---

please differentiate between delete and truncate?

956

---