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...(<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">