Re: Security log?

Are u talking about third party programs that can read the transaction
log?



On 12 Giu, 15:48, "Andrew J. Kelly" <sqlmvpnooos...@xxxxxxxxxxxx>
wrote:
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....@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- Nascondi testo tra virgolette -

- Mostra testo tra virgolette -


.