I am currently working on a SSIS configuration database. However, I am having trouble writing a script to get the the users that have each server role permissions. I'm pretty sure that I need to use sp_helpsrvrole, but am not sure where to go from here. If anybody has any ideas or has seen a script on the internet to get this then that would be a tremendous help.
Thanks in advance,
Kyle
Please try:
exec sp_helpsrvrolemember
this should get the server role membership information you are looking for. Let us know if you have any further questions.
-Raul Garcia
SDE/T
SQL Server Engine
No comments:
Post a Comment