Answer Posted / kalyana chakravarthy maddipati

A trigger is a stored procedure fires implicitly when ever a DML(Insert, update & Delete) occurs. It is stored at server side. Its compiled and no need to compile and execute always.

What is query cost in sql server?

1035

---

What is it’s similarity with sql server?

160

---

Is it possible to run multiple publications and different type of publications from the same distribution database? : sql server replication

1026

---

What Are the Main Features of SQL Azure?

121

---

Explain Geography datatype in SQL Server

1182

---

How many instances per computer are there in sql server 2000?

1116

---

What does it mean if @@cursor_row returns a negative number?

1032

---

Does full backup break log chain?

1009

---

How does recursive cte works in sql server?

1054

---

When is the use of update_statistics command?

1053

---

What is in place upgrade in sql server?

1087

---

How many types of built in functions are there in sql server 2012?

962

---

What is primary key, unique key, and foreign key?

1010

---

What is the latest version of microsoft sql server?

1108

---

How does stuff differ from the replace function?

1059

---