dbcc inputbuffer: looking for the actual statement

Hello all,
Is there a way to display (using TSQL) the actual statement that
a SPID is executing?
When I use dbcc inputbuffer(SPID) all I ever get is "sp_executesql;1" :-(
Thanks
PS: I cannot use the profilerPossibly fn_get_sql can be of help. There are some things to think about whe
n using this (it was
introduced in SQL2K sp3), so Google and KB search and read about it first.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Strider" <Strider@.discussions.microsoft.com> wrote in message
news:582B477A-97A3-447C-826F-270E784D84D9@.microsoft.com...
> Hello all,
> Is there a way to display (using TSQL) the actual statement that
> a SPID is executing?
> When I use dbcc inputbuffer(SPID) all I ever get is "sp_executesql;1" :-(
> Thanks
> PS: I cannot use the profiler|||Thank you Tibor.
This is just what I needed!
"Tibor Karaszi" wrote:

> Possibly fn_get_sql can be of help. There are some things to think about w
hen using this (it was
> introduced in SQL2K sp3), so Google and KB search and read about it first.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Strider" <Strider@.discussions.microsoft.com> wrote in message
> news:582B477A-97A3-447C-826F-270E784D84D9@.microsoft.com...
>
>

dbcc inputbuffer: looking for the actual statement

Hello all,
Is there a way to display (using TSQL) the actual statement that
a SPID is executing?
When I use dbcc inputbuffer(SPID) all I ever get is "sp_executesql;1" :-(
Thanks
PS: I cannot use the profilerPossibly fn_get_sql can be of help. There are some things to think about when using this (it was
introduced in SQL2K sp3), so Google and KB search and read about it first.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Strider" <Strider@.discussions.microsoft.com> wrote in message
news:582B477A-97A3-447C-826F-270E784D84D9@.microsoft.com...
> Hello all,
> Is there a way to display (using TSQL) the actual statement that
> a SPID is executing?
> When I use dbcc inputbuffer(SPID) all I ever get is "sp_executesql;1" :-(
> Thanks
> PS: I cannot use the profiler|||Thank you Tibor.
This is just what I needed!
"Tibor Karaszi" wrote:
> Possibly fn_get_sql can be of help. There are some things to think about when using this (it was
> introduced in SQL2K sp3), so Google and KB search and read about it first.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Strider" <Strider@.discussions.microsoft.com> wrote in message
> news:582B477A-97A3-447C-826F-270E784D84D9@.microsoft.com...
> > Hello all,
> >
> > Is there a way to display (using TSQL) the actual statement that
> > a SPID is executing?
> >
> > When I use dbcc inputbuffer(SPID) all I ever get is "sp_executesql;1" :-(
> >
> > Thanks
> >
> > PS: I cannot use the profiler
>
>

dbcc inputbuffer: looking for the actual statement

Hello all,
Is there a way to display (using TSQL) the actual statement that
a SPID is executing?
When I use dbcc inputbuffer(SPID) all I ever get is "sp_executesql;1" :-(
Thanks
PS: I cannot use the profiler
Possibly fn_get_sql can be of help. There are some things to think about when using this (it was
introduced in SQL2K sp3), so Google and KB search and read about it first.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Strider" <Strider@.discussions.microsoft.com> wrote in message
news:582B477A-97A3-447C-826F-270E784D84D9@.microsoft.com...
> Hello all,
> Is there a way to display (using TSQL) the actual statement that
> a SPID is executing?
> When I use dbcc inputbuffer(SPID) all I ever get is "sp_executesql;1" :-(
> Thanks
> PS: I cannot use the profiler
|||Thank you Tibor.
This is just what I needed!
"Tibor Karaszi" wrote:

> Possibly fn_get_sql can be of help. There are some things to think about when using this (it was
> introduced in SQL2K sp3), so Google and KB search and read about it first.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Strider" <Strider@.discussions.microsoft.com> wrote in message
> news:582B477A-97A3-447C-826F-270E784D84D9@.microsoft.com...
>
>

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
>