Answer / Barkha Saxena

In SQL Server, a trigger is a special type of stored procedure that automatically responds to certain database events (like INSERT, UPDATE, or DELETE). Triggers are defined for specific tables and execute when the specified event occurs against the table.nnUnfortunately, SQL Server triggers cannot be invoked on demand without actually performing the operation they're designed to react to.

What will be query used to get the list of triggers in a database?

1 Answers  

---

What is the standby server?

1 Answers  

---

Can a database be shrunk to 0 bytes, if not, why?

1 Answers  

---

Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?

1 Answers  

---

Mention the different authentication modes in sql server.

1 Answers  

---

How can you check the version of sql server?

1 Answers  

---

What do you understand by integration services in sql server?

1 Answers  

---

How to loop through result set objects using odbc_fetch_row()?

1 Answers  

---

What is cross join in sql server joins?

1 Answers  

---

what is cluster and nin-cluster index?

4 Answers  

---

what’s the difference between Covering Indexes and Clustered Indexes ? how to use clustered index small ?

1 Answers  

---

What is abstracting periodical?

1 Answers  

---