audit log

Are there any sys tables that store audit logs for
commands such as sp_changeobjectowner? Is this a feature
that can be turned on? If so where?
Thanks in advance :-)
TylerTyler,
Check the Profiler tool. It comes with SQL Server and is described in Books
OnLine. You can check some 3rd party tools as well, for example check
www.lumigent.com.
--
Dejan Sarka, SQL Server MVP
FAQ from Neil & others at: http://www.sqlserverfaq.com
Please reply only to the newsgroups.
PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"tyler" <e_tyler@.netzero.net> wrote in message
news:0cc801c35c2b$5e5edc10$a501280a@.phx.gbl...
> Are there any sys tables that store audit logs for
> commands such as sp_changeobjectowner? Is this a feature
> that can be turned on? If so where?
> Thanks in advance :-)
> Tyler

AUDIT all commands performed by Privileged Users on SQL 2000/2005

Is there any way to audit all commands executed by people with Sysadmin
access on SQL 2000 and SQL 2005 ? Any answer or suggestion would be greatly
appreciated.Hi
On SS2005 you are availalble to create a trigger on server/database level.
For moree details please refer to the BOL
"DDLooks" <DDLooks@.discussions.microsoft.com> wrote in message
news:893A8BF5-2298-4446-AC66-93840B922325@.microsoft.com...
> Is there any way to audit all commands executed by people with Sysadmin
> access on SQL 2000 and SQL 2005 ? Any answer or suggestion would be
> greatly
> appreciated.

Audit a SQl connection

hi ,

Is it possible to audit a sql Connection, and retrieve all the commands fired from that connection ,

or

how to find all commands fired to a database , as it is shown in " Profiler ".

and its command text .

Use Profiler, run a trace remotely.

Use Third party Auditing products

Audit Tools
ApexSQL Audit http://www.apexsql.com/sql_tools_audit.asp
AuditDatabase (Free Web based trigger generation) http://www.auditdatabase.com/
Lumigent Adit DB http://www.lumigent.com/products/auditdb.html
OmniAudit http://www.krell-software.com/omniaudit/index.asp
SQLLog http://www.rlpsoftware.com/mainframe.asp?contents=SQLLog.asp&mainmenu=SQLLog&submenu=Info
Upscene SQL Log Manager http://www.upscene.com/index.htm?./products/audit/mssqllm_main.htm
DB Audit Expert http://www.softtreetech.com/dbaudit/