April 23, 2013 at 4:20 am
Script to find the all the db roles of all the users in all the databases in sql 2005\2008
April 23, 2013 at 3:03 pm
Write a query to interrogate the following catalogue views:
sys.databases
http://msdn.microsoft.com/en-us/library/ms178534%28v=sql.100%29.aspx
sys.server_principals
http://msdn.microsoft.com/en-us/library/ms188786%28v=sql.100%29.aspx
April 24, 2013 at 6:57 am
Check out the Scripts library here on SSC. There are several scripts there that do this. You can do a search on security and then limit it to scripts.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply