For SQL Server, couldn't you just "rem" it out?  (basically leave it
there, but wrap /* and */ around the top/bottom of it)


-----Original Message-----
From: Bradford T Comer [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, August 09, 2005 14:02
To: SQL
Subject: Temporarily Disabling a Trigger

Is it possible to disable a trigger on a temporary basis? I guess I
could delete the trigger and then recreate it, but I was hoping
there was something more reasonable then this.

Any ideas?

Thanks,
Brad




~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:6:2336
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/6
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:6
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.6
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Reply via email to