Timeline for How to identify a client application whose host_process_id points to sqlserver.exe
Current License: CC BY-SA 4.0
2 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Sep 7, 2018 at 5:26 | comment | added | Solomon Rutzky |
Unless overridden via a connection string keyword, the program_name value for SQLCLR connections should be ".Net SqlClient Data Provider" (same as for the client_interface_name column). Just something to help narrow it down as I doubt many people override that value. Also, for filtering out the MS-provided assembly, it might be easier to simply do: WHERE a.[assembly_id] <> 1 or even WHERE a.[is_user_defined] = 1.
|
|
| Jul 6, 2018 at 15:08 | history | answered | Hannah Vernon♦ | CC BY-SA 4.0 |