Browse by Tags

All Tags » tsql » performance » application role (RSS)
Display the server-level information the application role can currently view.
Published 9 August 7 5:28 AM | SSQA.net
SELECT sid, status, name, dbname, hasaccess, loginname FROM master.dbo.syslogins; GO SELECT spid, kpid, lastwaittype, waitresource, dbid FROM master.dbo.sysprocesses; GO...( read more ) Read More...
Filed under: , , , ,