Answer Posted / maanu

Enterprise manager is a tool which comes with SQL Server 2k
and from there you can manage all the aspects of the SQL
Server 2k. But in order to write queries and T-SQL you have
to use Query Analyzer.
SQL Server Management Studio is combination of both SQL
Server Enterprise Manager + Query Analyzer of SQL 2k.

Is INSTEAD OF trigger directly applicable to Table ?

960

---

Can a database be shrunk to 0 bytes, if not, why?

1041

---

What is the most common type of join?

915

---

What are the advantages to use stored procedures?

1034

---

After removing a table from database, what other related objects have to be dropped explicitly?

1000

---

What is the web service used for reporting services?

114

---

Can a synonym name of a table be used instead of a table name in a select statement?

976

---

What are the different types of sub-queries?

997

---

How can we call UDF(User Define Function) using C# code in ASP.net ?

6802

---

How to disable stored procedure sql server?

1532

---

What is the difference between stored procedure and user defined functions?

1132

---

What is raid? : SQL Server Architecture

1106

---

Which operator do you use to return all of the rows from one query except rows are returned in a second query?

946

---

What is the use of tempdb? What values does it hold?

1003

---

Determine when to use stored procedure to complete sql server tasks?

988

---