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
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.



Acceptable Use Policy
---