Audit logs

Question

Audit logs

san-232591

SSC Rookie

Points: 43
More actions
August 21, 2005 at 8:05 pm

#102720

Can anyone tell me where can I find sql audit logs? Is it the same as sql server logs?
How can I add to audit DDL statement?
Thanks

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Chris Hedgate One Orange Chip Points: 25041 More actions · Answer 1

There are no automatic audit logs in SQL Server. You can use Profiler to trace any activity you want and store as audit logs if you wish. In SQL Server 2005 you could use DDL triggers to log DDL statements.

--
Chris Hedgate http://www.hedgate.net/
Contributor to the Best of SQL Server Central volumes
Articles: http://www.sqlservercentral.com/columnists/chedgate/

xblondel SSC Eights! Points: 818 More actions · Answer 2

Hi!

You can also use the sp_trace_* stored procedures, which enable you to do with T-SQL what the profiler does. They need a bit of practice, though.

Bye,

Xavier

Mark Hickin Say Hey Kid Points: 693 More actions · Answer 3

Hi, There are some tools out there that can assist with this type of requirement:

http://www.lumigent.com/products/le_sql.html

http://www.red-gate.com/sql/sql_log_rescue.htm

As far as I know, these tools are loosely based around the following query, which reveals the current entries within the transaction log:

SELECT * FROM ::FN_DBLOG(1,NULL)

Mark