List some major differences between triggers and stored procedures?

0 Answers  

---

Explain about protocol layer present in SQL server?

0 Answers  

---

explain databases and sql server databases architecture? : Sql server database administration

0 Answers  

---

which table keeps the locking information? : Sql server administration

0 Answers  

---

Can we return Data from 4(more than 1) tables in stored procedure?

0 Answers   HCL,

---

What is table constraint?

0 Answers  

---

how to copy sysdatabase file from c: Drive to D: Drive in SQL Server.

6 Answers   IBM,

---

How to add a new column to an existing table with "alter table ... Add" in ms sql server?

0 Answers  

---

1.What is the deferece between DBMS & RDBMS? 2.How can you trouble shoot? If u will get error while installing sql server? 3.How can u trouble shoot slow running query? 4.how can u trouble log shipping errors? 5.why do we use merge replication instead of T.log replication?

7 Answers   Microsoft,

---

Can we rollback records deleted by a truncate statement?

3 Answers   CarrizalSoft Technologies, United Healthcare,

---

Explain system functions or built-in functions? What are different types of system functions?

0 Answers  

---

Explain different types of index?

0 Answers  

---