October 16, 2008 at 8:18 am
Hi
I've searched and searched, maybe I'm searching for the wrong thing but I need to identify all the logins which have no databases associated with them and if possible logins which only have access to master, model or tempdb. It will need to be excluded if it is a member of any system roles though.
Thanks
B69
October 16, 2008 at 8:39 am
Since you are using 2000 you should check out the first post in this thread as it has some code that accesses the tables that you will need to look in and should give you some ideas:
http://www.sqlservercentral.com/Forums/FindPost586888.aspx
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 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply