What is the basic functions for master, msdb, tempdb databases?

2 Answers   CSC,

---

What happens if you delete a table that is used by a view?

0 Answers  

---

What is difference between after and before?

0 Answers  

---

explain declarative management framework (dmf) in sql server 2008?

0 Answers  

---

What is the difference between temp table and table variable?

8 Answers   Microsoft,

---

---

What is the difference between WHERE AND IN? OR 1. SELECT * FROM EMPLOYEE WHERE EMPID=123 2. SELECT * FROM EMPLOYEE WHERE EMPID IN (123) WHAT IS THE DIFFERENCE?

15 Answers   Adsys, Cap Gemini,

---

What is the difference between Stored Procedures and triggers?

0 Answers   HCL,

---

Lets say due to N/W or Security issues client is not able to connect to server or vice versa. How do you troubleshoot?

1 Answers  

---

What are the different Topologies in which Replication can be configured?

0 Answers  

---

what are questions asked in TCS for database tester (sqlserver)for 2-3 exp?

0 Answers   ABC, TCS,

---

Differentiate between a primary key and a unique key.

0 Answers  

---

Explain hostprotectionattribute in sql server 2005?

0 Answers  

---