Answer / Santosh Saraswat

Stored Procedures are precompiled collections of SQL statements and are called explicitly, while Triggers are automatically executed in response to certain events on a specific database object.

What are the recovery models in sql server 2000?

1 Answers  

---

How to check status of stored procedure in sql server?

1 Answers  

---

how many no of arguments can be passed in procedures and functions

2 Answers   ABC,

---

how to insert the values in 5 table at a time with triggers . if u have any solution then co-operate me ?

1 Answers  

---

How to attach adventureworkslt physical files to the server?

1 Answers  

---

What should be the fill factor for indexes created on tables? : sql server database administration

1 Answers  

---

how to rename the table

3 Answers  

---

How can we write or define DDL statements in Sql server and DML statements?

3 Answers  

---

What is difference between table aliases and column aliases? Do they affect performance?

1 Answers  

---

Can a database be shrunk with users active?

1 Answers  

---

CLR Integration ? what is Notification services ?

1 Answers   HCL, Satyam,

---

Explain what is sql server english query?

1 Answers  

---