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: 145

Filed under:

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.

(http://sqlserverpedia.com/blog/sql-server-bloggers/sql-server-%E2%80%93-get-last-running-query-based-on-spid/)

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

Related posts about sql-server-2008