Browse by Tags

• tables
• view

Display the server-level information the application role can currently view.
09 August 07 03:28 AM | SQL Master | 2 Comments   

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

Filed under: tsql, performance, tables, view, application role