Answer / Shashank Saxena

To view triggers: `SELECT * FROM sys.triggers`nTo drop a trigger: `DROP TRIGGER [schema_name].[trigger_name]`nTo disable a trigger: `DISABLE TRIGGER [schema_name].[trigger_name] ON [table_name]`nTo enable a trigger: `ENABLE TRIGGER [schema_name].[trigger_name] ON [table_name]`

can you any body tell me suppose database is suspect mode. how can take to normal?

2 Answers   Teledata,

---

Why I am getting "the microsoft .net framework 2.0 in not installed" message?

1 Answers  

---

What is the difference between dataadapter and datareader?

1 Answers  

---

What are the authentication modes in sql server? How can it be changed?

1 Answers  

---

What is sql server profiler?

1 Answers  

---

What do you understand by replication in sql server?

1 Answers  

---

what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration

1 Answers  

---

What is the default Port No on which SQL Server listens?

1 Answers  

---

What functions can a view be used to performed?

1 Answers  

---

What are the types of subquery?

1 Answers  

---

what is the importence of the trigger in sqlserver2000?

1 Answers   ATI,

---

How to list all tables having unique constraints in any of the columns in a database.

1 Answers  

---