Answer / 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.

Answer / prasad

Entere prise manager+ Query Analyzer =
Entereprise management studio

What is the status of services on passive node for failover cluster in sql server? : sql server database administration

0 Answers  

---

employee table has employee id ----------- empid ---------------- 1 2 3 3 3 4 5 5 5 6 6 6 7 here the values r repeated two times.how to select the repeated values only.i.e 3,5,6 should alone come.

3 Answers  

---

What is normalization and its types?

0 Answers  

---

What is 5nf in normalization form?

0 Answers  

---

How to loop through result set objects using odbc_fetch_row()?

0 Answers  

---

---

How many jobs will create for Mirroring, Log Shipping, and Transactional Replication?

4 Answers   IBM,

---

you notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it? : Sql server administration

0 Answers  

---

Differentiate between truncate vs delete in mssql?

0 Answers  

---

How to create a view using data from another view?

0 Answers  

---

Write a query for primary key constraint with identity key word?

0 Answers   MindCracker,

---

What is database black box testing?

0 Answers  

---

What is change data capture (cdc) in sql server 2008?

0 Answers  

---