Answer Posted / kavithareddy

like as storeprocedure
it is userdefind function ther is no parameters

1)After trigger:

2)Insted of trriger

Explain following error properties?

954

---

What happens if you insert a duplicate key for the primary key column in ms sql server?

930

---

What is unique key constraint?

987

---

What is page-level compression?

901

---

What is primary key index?

917

---

Explain raiserror in sql server?

961

---

What is it’s similarity with sql server?

160

---

What is tempdb in sql server?

919

---

What is the difference between resultset and resultsetmetadata?

887

---

Tell me what is sql profiler?

976

---

Can a trigger be created on a view?

892

---

Do you know sql server 2008 introduces automatic auditing?

901

---

What are key, name and value columns of an attribute? : sql server analysis services, ssas

944

---

What different steps will a sql server developer take to secure sql server?

927

---

Other than truncate statement, which other command can by-pass the trigger on the tables?

1064

---