MSSQLTips

MSSQLTips.com - your daily source for SQL Server tips

Welcome to MSSQLTips Sign in | Join | Help

MSSQLTips » Tip Forums » Tip Discussions » Disabling a Trigger for a Specific SQL Statement or Session

Disabling a Trigger for a Specific SQL Statement or Session

Last post 10-01-2008 11:39 AM by Mstarr. 2 replies.

Page 1 of 1 (3 items)
	Sort Posts: Previous Next

09-25-2008 12:30 AM

admin
Joined on 10-08-2007
Posts 1,156

Disabling a Trigger for a Specific SQL Statement or Session

Reply Contact

This post is related to this tip: Disabling a Trigger for a Specific SQL Statement or Session

http://www.mssqltips.com/tip.asp?tip=1591

09-30-2008 11:31 AM In reply to

sandeepbattina
Joined on 09-30-2008
Posts 1

Re: Disabling a Trigger for a Specific SQL Statement or Session

Reply Contact

wonderful article,really helpful

10-01-2008 11:39 AM In reply to

Mstarr
Joined on 10-01-2008
Posts 1

Re: Disabling a Trigger for a Specific SQL Statement or Session

Reply Contact

Great tip: didn't know about user-definable Context_Info.
I'm a minimalist, though....
instead of 4 lines:
DECLARE @Cinfo VARBINARY(128)
SELECT @Cinfo = Context_Info()
IF @Cinfo = 0x55555
RETURN
The following seems to work as well:
IF (Context_info() = 0x55555) return

Cheers

Page 1 of 1 (3 items)