Answer / Priyanka Prajapati

Yes, SQL Server Management Studio allows you to work with multiple databases simultaneously. You can connect to various instances and databases within a single instance through the Object Explorer.

How do you fine the performance tunning?

2 Answers   Accenture,

---

What is the use of toad or sqldbx.?

1 Answers   MCN Solutions,

---

Can we hide the definition of a stored procedure from a use?

1 Answers  

---

What is the difference between varchar and nvarchar datatypes?

1 Answers  

---

ehat is the default port no of sql 2000?

2 Answers   IBM,

---

What is referential integrity and how is it achieved?

1 Answers   Adea Solutions,

---

How will you know when statistics on a table are obsolete?

1 Answers  

---

Can an automatic recovery be initiated by a user?

1 Answers  

---

Indexes are updated automatically is the full-text index also updated automatically?

1 Answers  

---

Differentiate between truncate vs delete in mssql?

1 Answers  

---

how to find number of columns in a table in sql server 2000 and 2005 also

7 Answers   HCL, Virtusa,

---

What options are available to audit login activity? : sql server security

1 Answers  

---