Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 input buffer(id) output help

Author  Topic 

alejo46
Posting Yak Master

157 Posts

Posted - 2010-05-06 : 17:04:03
Good afternoon

with the command dbbb inputbuffer(id) i can see the last command in an user session whuch is running,but in some sessins its output or the result is, for instance:

sp_prexec:1. ò sp_execute:1

it doesnt show me more details, nor which command is running, etc.

its seems to be a linked server.

how can i know exactly what command is running ?

i appeciate your help

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-05-06 : 17:05:50
Those are prepared statements. You'll need to run SQL Profiler to see better data.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

alejo46
Posting Yak Master

157 Posts

Posted - 2010-05-06 : 17:16:02
thanks, but the question is, in sqlserver 2008 i can use this tollo because sql profiles is included, but in sqlserver 2000?
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-05-06 : 17:38:55
SQL Profiler is the tool to use in SQL Server 2000 too.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
   

- Advertisement -