Follow SQLMaster on Twitter
Welcome to SqlServer-QA.net Sign in | Help

Display the server-level information the application role can currently view.

SELECT sid, status, name, dbname, hasaccess, loginname
FROM master.dbo.syslogins;

GO


SELECT spid, kpid, lastwaittype, waitresource, dbid
FROM master.dbo.sysprocesses;
GO

Published Thursday, August 09, 2007 3:28 AM by SQL Master

Comments

# Display the server-level information the application role can currently view.

SELECT sid, status, name, dbname, hasaccess, loginname FROM master.dbo.syslogins; GO SELECT spid, kpid

Thursday, August 09, 2007 3:45 AM by Other SQL Server Blogs around the Web

# Display the server-level information the application role can currently view.

SELECT sid, status, name, dbname, hasaccess, loginname FROM master.dbo.syslogins; GO SELECT spid, kpid

Thursday, August 09, 2007 11:08 AM by SSQA.net - SqlServer-QA.net
Anonymous comments are disabled