sp_helpuser SELECT * FROM sys.database_principals SELECT loginname FROM syslogins where loginname like '%NAME%' EXEC sp_helplogins
sp_helpuser SELECT * FROM sys.database_principals SELECT loginname FROM syslogins where loginname like '%NAME%' EXEC sp_helplogins