Re: Queries Fired

From: BP Margolin (bpmargo@attglobal.net)
Date: 11/28/02 

From: "BP Margolin" <bpmargo@attglobal.net>
Date: Thu, 28 Nov 2002 01:57:44 -0500

At any instance in time, you can use the DBCC INPUTBUFFER command to see the
last query fired by each user ... DBCC INPUTBUFFER will only display the
first, I believe, 255 characters and there is no way to change this setting.

Keep in mind that the original posting requested a log of the queries issued
by each user, and DBCC INPUTBUFFER just offers a snapshot image of the
current activity, not a log of the activity.

Documentation on the DBCC INPUTBUFFER command can be found in the SQL Server
Books Online.

-------------------------------------------
BP Margolin
Please reply only to the newsgroups.
When posting, inclusion of SQL (CREATE TABLE ..., INSERT ..., etc.) which
can be cut and pasted into Query Analyzer is appreciated.

"~College Guy~" <janus@nettaxi.com> wrote in message
news:ORmfSMplCHA.2032@tkmsftngp02...
> Hi there,
> Suppose I do not wish to use the SQL Profiler. Is there still a way to
> get a look at the last queries fired?
>
> ~College Guy~
>
>
>
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!

Relevant Pages