SQL Server Performance

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

Discussion in 'Other SQL Server Blogs around the Web' started by Anonymous, Aug 9, 2007.

  1. Anonymous New Member

    SELECT sid, status, name, dbname, hasaccess, loginname FROM master.dbo.syslogins; GO SELECT spid, kpid, lastwaittype, waitresource, dbid FROM master.dbo.sysprocesses; GO...(<a href="http://sqlserver-qa.net/blogs/t-sql/archive/2007/08/09/1334.aspx">read more</a>)<img src="http://sqlserver-qa.net/aggbug.aspx?PostID=1334" width="1" height="1">

Share This Page