April 28, 2010 at 9:22 am
Hey guys
Help me its damm urgent
I need to Get the list of logins and the respective username in the databases in sql server 2005
the result should be
Login_name,Database_name,User_name
Thanks a lot in advance
April 28, 2010 at 10:03 am
What have you tried so far? Lookup database_principals and server_principals in books online.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
April 28, 2010 at 10:08 am
Thank you for your efforts
some how i figured it
Here is the query
Declare @login table ( Database_name Varchar(1000),Login_Name varchar(2000),Username varchar(200))
Insert into @login
exec sp_msforeachdb @command1= 'USE [?]; select db_name(), ss.name ,dp.name from sys.syslogins ss left join sys.database_principals dp on ss.sid = dp.sid where dp.type not like ''R'''
Select * from @login where Database_name not in ( 'master','model','msdb','tempdb')
thank you again
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply