June 24, 2004 at 10:50 pm
What I am really trying to do is create a script that will list all permissions for any role that doesn't start with db_ on every database.
Does anybody have something like that?
Could you point me in the right direction for a loop that will execute a statement for each database in an instance?
I found a great script on this sight for the main part of my problem!! This site is awesome.
http://www.sqlservercentral.com/scripts/contributions/1080.asp
So i am still clueless for setting up a looping structure to run this sp on each of the databases.
June 25, 2004 at 12:09 am
June 28, 2004 at 7:50 am
You may also want to check out: sp_helplogins
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy