Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
cshekar
Starting Member
49 Posts |
 Posted - 2004-09-28 : 12:53:35
|
| I wanted turn off trigger on one table for soem time after testing is done and I wanted put back the trigger Could some can help me to how do i do that TURN OFF TRIGGER on tableand bring it back.can I do it in Em or by SQL Statement in Query Analyzer ??chandra shekar |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-09-28 : 12:55:12
|
| ALTER TABLE Table1 DISABLE TRIGGER TriggerNameTara |
 |
|
|
cshekar
Starting Member
49 Posts |
Posted - 2004-09-28 : 13:39:42
|
| Thank youchandra shekar |
|
|
|
|
|
|
TRUN OFF TRIGGER