Security log?

From: kain.vma@xxxxxxxxx
Date: Tue, 12 Jun 2007 06:32:36 -0700

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

.

Follow-Ups:
- Re: Security log?
  - From: vt
- Re: Security log?
  - From: Andrew J. Kelly

Prev by Date: Re: ODBC login problem
Next by Date: Re: Security log?
Previous by thread: Re: permissions required for executing CDOSys stored procedures
Next by thread: Re: Security log?
Index(es):
- Date
- Thread

Relevant Pages

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: Windows forms application and database back-up
... What you write is valid as it is running as multi user source, but as it is single user like the OP wrote, than in my idea simple make copies has the same effect. ... I was also going for the backup/restore, but rejected that because it has in my idea no advantages in a single user situation. ... attached to the SQL Server instance), ... The other option would be to use SQL Server Express' USER INSTANCE, to which, the user do not have to have local admin rigth to attach database to SQL Server Express instance. ...
(microsoft.public.dotnet.general)
Re: Visual C# Express question
... > not sharable and the user can admin the thing without being admin. ... > pretty cool way to go if you just need a db for your single user app. ... >> "Easily move or copy your SQL Server Express databases to another ... >> Voodoo Programming: Things programmers do that they know shouldn't work ...
(microsoft.public.dotnet.framework)
Re: Mystery Table Delete!
... www.apexsql.com to trawl trough your transaction logs and see what happened. ... SQL Server MVP ... >>> 29 tables in our live database were deleted the other ... >>> Description: 3041: BACKUP failed to complete the command ...
(microsoft.public.sqlserver.server)