Saturday, February 25, 2012

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/

No comments:

Post a Comment