Answer Posted / koti-khammam

Trigger is a special type of stored procedure that will
fire automatically when ever data modifications like
INSERTIONS,UPDATIONS or DELETIONS occurs on the table.

How do you send email on SQL Server?

1038

---

What gets stored inside msdb database?

1233

---

How to find the version of sql server? : sql server database administration

1087

---

What are triggers? How do you invoke a trigger on demand?

1295

---

What is a view in sql?

958

---

What is scalar user-defined function?

1074

---

how to use DTS package in 2000,2005,2008 in sql server

1818

---

How do you drop an index?

904

---

How do you implement session management in SQL Server mode?

1072

---

How to create an index on an existing table in ms sql server?

958

---

How can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role?

1017

---

What are the fixed server level roles? : sql server security

1104

---

What is awe?

989

---

sql database suspect We have a sql database that is showing as suspect. How can we recover?

1906

---

whats the maximum size of view state??

2176

---