I am trying to troubleshoot an issue that is popping up on our new SQL Server. While viewing the running processes (sp_who2
) I can't tell what parameters a proc was started with.
I can find the name of the proc using: DBCC INPUTBUFFER (spid)
I can even find some additional info, but I can't see a way to show the parameters.
I know I can see the parameters if I do a trace, but that doesn't help in this case.