http://www.sqlslayer.com/wp/admin-database/
- Updated who_vw to use OUTER APPLY vs. CROSS APPLY on dm_exec_sql_text as connections with no query text returned would not show up. Still need to COALESCE the query to return from sysprocesses as sysprocesses will contain the text that dm_exec_sql_text doesn’t. Amazes me how sysprocesses is still required on many different levels.
Comments