<p>Is it possible to disable a trigger for a batch of commands and then enable it when the batch is done?</p>

<p>I'm sure I could drop the trigger and re-add it but I was wondering if there was another way.</p>

```
```
DISABLE TRIGGER { [ schema_name . ] trigger_name [ ,...n ] | ALL }
ON { object_name | DATABASE | ALL SERVER } [ ; ]
```
```
http://msdn.microsoft.com/en-us/library/ms189748(SQL.90).aspx
followed by the inverse:
```
```
ENABLE TRIGGER { [ schema_name . ] trigger_name [ ,...n ] | ALL }
ON { object_name | DATABASE | ALL SERVER } [ ; ]
```
```
http://msdn.microsoft.com/en-us/library/ms182706(SQL.90).aspx