how could I see which user run what query on the datbase
(sql 2000) at what time. pl help
regards, shahidYou need to have a trace running at that point-in-time, to see what the
users were running at that time. Do you have one?
Or you need to have some sort of logging in your application or stored
procedures.
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"shahid" <anonymous@.discussions.microsoft.com> wrote in message
news:2b13201c467fb$a8013480$a401280a@.phx
.gbl...
how could I see which user run what query on the datbase
(sql 2000) at what time. pl help
regards, shahid|||Hi,
SQL Server will not log any Select statements. Only way to look into that is
activate Profiler. You can save the profiler output to a Table for analysis.
FYI, You can see the information only from the point you activate the
profier.
For doing this you could use the GUI interface Profiler or look into the
books online for the procedure "sp_trace_create".
Thanks
Hari
MCDBA
"shahid" <anonymous@.discussions.microsoft.com> wrote in message
news:2b13201c467fb$a8013480$a401280a@.phx
.gbl...
> how could I see which user run what query on the datbase
> (sql 2000) at what time. pl help
> regards, shahid
