Find out the commands executed

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!
dbUse can use the SQL Server Profiler to capture the sql commands against a
given database.
regards, -marty nicholson
"Dan" <danjbart@.yahoo.com> wrote in message
news:fa556b4d.0307191812.12948b98@.posting.google.com...
> 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|||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
"Dan" <danjbart@.yahoo.com> wrote in message
news:fa556b4d.0307191812.12948b98@.posting.google.com...
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