We have a stores database on SQL Server 2000. What I need to know is
the exact changes (or what ever the sql commands that are executed)
during a specific interval of time on the StoreDatabase.
e.g. between 10:15 AM and 10:30 AM.

Is there anyway I could do that?

Thanks for helping!

Use can use the SQL Server Profiler to capture the sql commands against a
given database.

regards, -marty nicholson

[quoted text, click to view]

As already suggested Profiler or a server side trace could be used if you
are interested in future events, if you want to have a look at what happened
in the past then the only tool really available would be Log Explorer from
www.lumigent.com

--
HTH

Jasper Smith (SQL Server MVP)

I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org

[quoted text, click to view]
We have a stores database on SQL Server 2000. What I need to know is
the exact changes (or what ever the sql commands that are executed)
during a specific interval of time on the StoreDatabase.
e.g. between 10:15 AM and 10:30 AM.

Is there anyway I could do that?

Thanks for helping!

db