Query to Select Login & User ID

Question

Post reply

Query to Select Login & User ID

Viewing 5 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

steveb. SSC-Forever Points: 46733 More actions · Answer 1

SELECT * FROM sys.database_principals

WHERE TYPE = 's'

Lori-138565 Ten Centuries Points: 1340 More actions · Answer 2

There's also this:

select b.uid, b.name as username,a.name as login

from master.dbo.syslogins a, sysusers b

where a.sid = b.sid

Thanks,

Lori

RJ-476420 SSCarpal Tunnel Points: 4806 More actions · Answer 3

select db_name(), b.name as username,a.name as login

from master.dbo.syslogins a, sysusers b

where a.sid = b.sid and b.issqluser = 1

The above query was very useful for my scenario. I also added issqluser just to track down by sql login.

tnk y'all.

Paresh Prajapati SSCertifiable Points: 7567 More actions · Answer 4

DECLARE @sql varchar(8000)

DECLARE @BAK_PATH VARCHAR(4000)

declare c_bak cursor FAST_FORWARD FOR

select name from sys.databases

OPEN c_bak

FETCH NEXT FROM c_bak INTO @BAK_PATH

WHILE @@FETCH_STATUS = 0

BEGIN

SET @sql = 'sp_helpuser'

PRINT (@SQL)

EXEC(@SQL)

FETCH NEXT FROM c_bak INTO @BAK_PATH

END

CLOSE C_BAK

DEALLOCATE C_BAK

_____________________________________________________________________________________________________________
Paresh Prajapati
➡ +919924626601
http://paresh-sqldba.blogspot.com/[/url]
LinkedIn | Tweet Me | FaceBook | Brijj

krayknot SSCertifiable Points: 7998 More actions · Answer 5

steveb (11/18/2008)
SELECT * FROM sys.database_principals
WHERE TYPE = 's'

thanks for knowledge updation

kshitij kumar
kshitij@krayknot.com
www.krayknot.com