Software

Ask something
Discussion Locked

How do i see all the queries?

0 helpful
1 reply

by arachief

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hi everybody,

I'll like to know how to find out all the queries that have been executed against my database at the end of the day. Database is Sql Server 7.0 and any help will be highly appreciated. Thanks!!!

1 reply

by glen_mcleod

This is for SQL 2000, but should be practicaly the same for 7.0.

Start SQL Profiler, and trace on "TSQL/SQL:Stmtcompleted" for ad hoc queries and "Stored Procedures/SP:Completed" for any storped procedures that may be executed.

In the filters,you can limit the events traced to your database only and not the server as a whole.

Glen

This discussion is closed to new replies.