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 |
|
Ex
Posting Yak Master
166 Posts |
 Posted - 2005-03-28 : 21:21:18
|
| this might be a weird question but i was wondering is there a way to disable triggersso saydisable triggers on my tableinsert into my tableenable triggers on my tablecan this be done? |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2005-03-28 : 21:26:48
|
| ALTER TABLE myTable DISABLE TRIGGER ALLINSERT INTO myTable...blah blahALTER TABLE myTable ENABLE TRIGGER ALLI do this quite often on certain tables I have to load a lot of data into, but don't want to have audited by the triggers. |
 |
|
|
|
|
|
disable triggers