November 4, 2002 at 9:37 pm
Hi All,
Do you have any way to know the text of the last query that was fired at a SQL Server 7.0 database?
In Oracle a user having DBA role is allowed to query a special table v$sql to get the queries that are fired at the database. What do you do in SQL Server ?
Thanks & Regards,
Abhijit
November 7, 2002 at 8:00 am
This was removed by the editor as SPAM
November 7, 2002 at 10:12 am
the inputbuffer has the values for each user. Not for the database. Guess you could query sysprocesses to find out who had the last query (there's a timestmap in here) and then get their inputbuffer (dbcc inputbuffer)
Steve Jones
http://qa.sqlservercentral.com/columnists/sjones
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply