Answer Posted / narasimha

1)sqlserver 2000 contain query analyzer and enterprise
manger as a seperate tools but sqlserver 2005 contains a
single management studio(query analyzer + enterprise
manger).

2)sql 2005 contain CLR Integration

3)sql 2005 contain sqlserver business intelegent management
studio for dedugging sp's.

4)CLR stored procedures

Explain what stored procedure sp_replcounters is used for? : sql server replication

1518

---

How to call a function from a stored procedure in SQL Server ?

1029

---

What is lock escalation? : sql server database administration

1160

---

What are 3 ways to get a count of the number of records in a table?

1078

---

Mention the different types of triggers?

1118

---

Can you create a logon trigger in sql server 2005 express edition?

1081

---

What does sql server mean?

1071

---

How to delete existing triggers using "drop trigger"?

1054

---

How do you delete a trigger?

982

---

What is policy based management (pbm)? : sql server database administration

988

---

What are the properties of sub-query?

1074

---

How much is a sql server license?

955

---

How do I schedule a sql server profiler trace?

981

---

What are the different types of indexes?

1119

---

What are the steps to take to improve performance of a poor performing query? : sql server database administration

1054

---