How can I run sp_addrolemember in a trigger?

Last Post 14 Jun 2006 09:19 AM by dbandee. 1 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
ufohj
New Member
New Member

--
29 May 2006 05:08 AM
How can I run sp_addrolemember in a trigger?

MS:sp_addrolemember cannot be used inside a user-defined transaction.

Is there any other ways?

Thanks.
dbandee
New Member
New Member

--
14 Jun 2006 09:19 AM

try creating another stored procedure. For example Trigger will execute a procedure that executes sp_addrolemember.

You are not authorized to post a reply.

Acceptable Use Policy