Answer / Namrata

There is no hard limit on the number of triggers you can create for a specific table in MS SQL Server, but each trigger consumes resources and may impact performance. It's best practice to keep the number of triggers minimal and ensure they are well-designed and efficient.

How do I run a trace in sql server?

1 Answers  

---

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

1 Answers  

---

What is difference between stored procedure and user defined function?

1 Answers  

---

What are ddl triggers and types of ddl trigger?

1 Answers  

---

Do you know what is sql injection?

1 Answers  

---

How do I port a number to sql server?

1 Answers  

---

What are the difference between primary keys and foreign keys?

1 Answers  

---

How to retrieve error messages using mssql_get_last_message()?

1 Answers  

---

What is molap and its advantage? : sql server analysis services, ssas

1 Answers  

---

About Indexed Views? with example? plz reply...

2 Answers  

---

What is built-in/administrator?

1 Answers  

---

Explain isolation levels that sql server supports?

1 Answers  

---