Unanswered: Using stored procedure sp_helpuser in a triggers
I would like to create a trigger and using the stored procedure sp_helpuser. The reason is that I want to pass the role to this stored procedure so it gives me the list of users in that role. And so,
with that list of users, I want to check with the triggers if the user added is in that list. The problem is that the sp_helpuser stored procedure returns me a bool and output the results... What I would like is to "save" the output in a variable so I can use and compare it to the inserted table...
I would like to know if that solution is possible and if not, is there any better solution.