Re: Security log?

No it does not. You either have to have a trace running to capture the
results or you can use one of the 3rd party tools to explore the log file
but those will not show selects.

See Profiler and Trace in BooksOnLine for more details.

--
Andrew J. Kelly SQL MVP

<kain.vma@xxxxxxxxx> wrote in message
news:1181655156.902260.39000@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Hi all!
I'm writing you to ask something about security of sql server 2000.

I want to know if SQL server 2000 logs every kind of command that a
user does (for examlpe a query or an update) and if yes where...I'm
trying to discover what a single user has done on a db.

There is a table that sql server uses for logging this kind of info?
or the only method is to use the sql server profiler?

Thanks!

p.s.: sorry for my english



.

Relevant Pages

  • Re: Security log?
    ... Are u talking about third party programs that can read the transaction ... I'm writing you to ask something about security of sql server 2000. ... trying to discover what a single user has done on a db. ... or the only method is to use the sql server profiler? ...
    (microsoft.public.sqlserver.security)
  • Re: database updation log
    ... You need to have a trace running at that point-in-time, ... Vyas, MVP (SQL Server) ... how could I see which user run what query on the datbase ...
    (microsoft.public.sqlserver.security)
  • Re: migrating from access: mdb or sql server files or what
    ... For a single user ans single computer, and Access installed, you already ... Why convert it to SQL Server (even the license ... > insert in a mdb table. ...
    (microsoft.public.vb.database)
  • Re: Access / DAO - Whats the Future
    ... when the schema changes. ... Would you recommend that we change to SQL Server Express? ... (single user, no install required - just copy&paste assemblies). ... RightHand .NET consulting & development www.rthand.com ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: fine tuned tracing for sql server job execution
    ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) www.SQLDTS.com - The site for all your DTS needs. ... > I'm thinking of using sql server profiler and/or the windows performance> logs, to trace a problematic job which> fails to retrieve any rows by executing a dts (which inbcludes transfare> data tasks). ...
    (microsoft.public.sqlserver.dts)