Create a Audit Log

Question

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

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

Ron McCullough SSC Guru Points: 63877 More actions · Answer 1

May I suggest that you read Books On Line (DDL Triggers) starting with

This will lead you to other pages which are quite specific, with example code, which I hope will answer your question.

If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read[/url]
Before posting a performance problem please read[/url]

nwinningham SSC-Addicted Points: 405 More actions · Answer 2

SSC-Addicted

Points: 405

December 11, 2008 at 11:16 am

Thanks

RBarryYoung SSC Guru Points: 143329 More actions · Answer 3

By "changes to the database" do you mean changes to the data or changes to the definitions and structures?

[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung [font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]

nwinningham SSC-Addicted Points: 405 More actions · Answer 4

Yes, I mean changes to the data or changes to the definitions and structures.

RBarryYoung SSC Guru Points: 143329 More actions · Answer 5

nwinningham (12/11/2008)
I would like the user name, what they did and when they did it.

Define what you mean and want for "what they did". The answer to this determines how hard this is and how much overhead is involved.

[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung [font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]

nwinningham SSC-Addicted Points: 405 More actions · Answer 6

I just want to know what type of modification was done.(delete, insert, update)