How to disable triggers using "disable trigger"?



How to disable triggers using "disable trigger"?..

Answer / Robin Singh

To disable a trigger in MS SQL Server, you can use the DISABLE TRIGGER command followed by the trigger name.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL Server Interview Questions

Explain ranking functions?

1 Answers  


What are different types of raid levels?

1 Answers  


What is best institute to Learn DotNET And SQL in chennai?

1 Answers  


Tell me what is difference between clustered and non clustered index?

1 Answers  


What are the authentication modes in SQL Server?

4 Answers   IBM, iSmart,


Where is SQL Srever (In sQL server 2005/2008 where is SQL Server Located).

2 Answers   TCS,


Can we hide the definition of a stored procedure from a use?

1 Answers  


Does dbcc checkdb requires db to be in single_user mode? : sql server database administration

1 Answers  


What is normalization? Explain its different types?

1 Answers   GE, Maveric,


If a stored procedure is taking a table data type, how it looks?

2 Answers  


What is the difference between a HAVING CLAUSE and a WHERE CLAUSE?

11 Answers   World Tech, Yardi Software,


write down the code for "how we delete a table without using of Drop command " ?

7 Answers   CarrizalSoft Technologies, Sonata,


Categories