How do I view the parameters of currently running procs in SQL Server 2008
Posted
by
Pez
on Stack Overflow
See other posts from Stack Overflow
or by Pez
Published on 2011-01-10T16:59:59Z
Indexed on
2011/01/10
21:54 UTC
Read the original article
Hit count: 147
sql-server-2008
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.
© Stack Overflow or respective owner