Answer / Himanshu Gupta

Triggers are automated routines that are automatically executed by SQL Server when specific events occur within the database. These events can be data modification events such as INSERT, UPDATE, or DELETE operations on a table. Triggers help maintain data integrity and enforce business rules.

What protocol does sql server use?

1 Answers  

---

Can we use max in where clause?

1 Answers  

---

How do I shrink an ldf file?

1 Answers  

---

How do I setup a sql server database?

1 Answers  

---

What it means to be triggered?

1 Answers  

---

Explain the different index configurations a table can have?

1 Answers  

---

How can we solve concurrency problems?

0 Answers  

---

explain different types of jions with examples briefly?

1 Answers   Zensar,

---

When do we use the UPDATE_STATISTICS command?

4 Answers   Deutsche Telekom AG,

---

How can I know what query is executing by by a particural user? (using sp id or any othe way.)

2 Answers  

---

what are the Prerequisites for Replication?

2 Answers   IBM,

---

What is mean by candidate key?

1 Answers  

---