Best way to audit objects in SQL 2005

Question

Post reply

Best way to audit objects in SQL 2005

M Garcia

SSC Enthusiast

Points: 192
More actions
April 5, 2013 at 11:50 am

#276172

I have a server running SQL Server 2005 Standard and I have been asked to audit server/database object events (create, alter and delete). What the best way to accomplish this with the least amount of overhead in performance?
Regards
MG

Viewing 6 posts - 1 through 5 (of 5 total)

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

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 1

Lynn Pettis

SSC Guru

Points: 442467

April 5, 2013 at 11:55 am

#1604051

Look at server sides traces.

M Garcia SSC Enthusiast Points: 192 More actions · Answer 2

Hey Lynn,

I am new to this so some patience maybe required.

By traces are you referring to Profiler? How would performance be impacted?

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 3

M Garcia (4/5/2013)
Hey Lynn,
I am new to this so some patience maybe required.
By traces are you referring to Profiler? How would performance be impacted?

No, I am not refering to Profiler unless you are using it to create the necessary script to create a server side trace.

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 4

Start here: http://msdn.microsoft.com/en-us/library/ms191443(v=SQL.105).aspx.

M Garcia SSC Enthusiast Points: 192 More actions · Answer 5

M Garcia

SSC Enthusiast

Points: 192

April 5, 2013 at 12:35 pm

#1604080

Thank you Lynn.......