| Author |
dbcc inputbuffer does not list parameters
|
|
| Hassan 2006-02-06, 3:23 am |
| I have a lot of sprocs being called but a dbcc inputbuffer on the spid only
lists the sproc name without the parameters being passed. Why is that ?
Using SQL 2000 and SP3a. Thanks
| |
| Uri Dimant 2006-02-06, 3:23 am |
| Hassan
I did some testing in the QA
exec spMySP '%spinsert%'
EventType Parameters EventInfo
-------------- ---------- ----------------------------------------------------------
Language Event 0 spMySP '%spinsert%'
"Hassan" <Hassan@hotmail.com> wrote in message
news:O7sSjLtKGHA.524@TK2MSFTNGP09.phx.gbl...
>I have a lot of sprocs being called but a dbcc inputbuffer on the spid only
>lists the sproc name without the parameters being passed. Why is that ?
>Using SQL 2000 and SP3a. Thanks
>
| |
| Jack Vamvas 2006-02-06, 7:23 am |
| Try this:
1)Execute the relevant sproc from Query Analyzer within the correct db
2)identify the @@spid used - through a SELECT @@spid
3)Open another window with Query Analyzer - make sure the db is set at
MASTER . execute dbcc inputbuffer(@@spid) --from step 2
--
Jack Vamvas
____________________
____________________
____________________
______
Receive free SQL tips - register at www.ciquery.com/sqlserver.htm
SQL Server Performance Audit - check www.ciquery.com/sqlserver_audit.htm
New article by Jack Vamvas - SQL and Markov Chains -
www.ciquery.com/articles/art_04.asp
"Hassan" <Hassan@hotmail.com> wrote in message
news:O7sSjLtKGHA.524@TK2MSFTNGP09.phx.gbl...
> I have a lot of sprocs being called but a dbcc inputbuffer on the spid
only
> lists the sproc name without the parameters being passed. Why is that ?
> Using SQL 2000 and SP3a. Thanks
>
>
| |
| Hassan 2006-02-06, 8:23 pm |
| These are for RPC calls made from our application.
If I run the trace, i see the parameters called but not through dbcc
inputbuffer
"Jack Vamvas" < DELETE_BEFORE_REPLY_
jack@ciquery.com> wrote in message
news:ds76pr$74s$1@nw
rdmz03.dmz.ncs.ea.ibs-infra.bt.com...
> Try this:
>
> 1)Execute the relevant sproc from Query Analyzer within the correct db
> 2)identify the @@spid used - through a SELECT @@spid
> 3)Open another window with Query Analyzer - make sure the db is set at
> MASTER . execute dbcc inputbuffer(@@spid) --from step 2
>
> --
> Jack Vamvas
> ____________________
____________________
____________________
______
> Receive free SQL tips - register at www.ciquery.com/sqlserver.htm
> SQL Server Performance Audit - check www.ciquery.com/sqlserver_audit.htm
> New article by Jack Vamvas - SQL and Markov Chains -
> www.ciquery.com/articles/art_04.asp
>
> "Hassan" <Hassan@hotmail.com> wrote in message
> news:O7sSjLtKGHA.524@TK2MSFTNGP09.phx.gbl...
> only
>
>
|
|
|
|