dbcc inputbuffer does not list parameters

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. ThanksHassan
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
>|||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
>|||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@.nwrdmz03.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
>

dbcc inputbuffer does not list parameters

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. ThanksHassan
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
>|||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
>|||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@.nwrdmz03.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...
>> 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
>>
>

dbcc inputbuffer does not list parameters

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
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
>
|||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
>
|||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@.nwrdmz03.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
>