October 28, 2008 at 1:20 pm
We are trying to make a call to sp_addsrvrolemember within a trigger and are getting the following error:
Msg 15002, Level 16, State 1, Procedure sp_addsrvrolemember, Line 14
The procedure 'sys.sp_addsrvrolemember' cannot be executed within a transaction.
We realize that sql server creates an implicit transaction for triggers but can it be turned off in some manner.
We've tried using SET IMPLICIT_TRANSACTIONS OFF before the call to the sp but it continues to fail.
Is there a workaround so that the sp can be called within the trigger?
October 28, 2008 at 1:38 pm
You probably should try another approach. What are you really trying to do with this?
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply