1 Kicks

SQL Server: How to audit rollback-ed data in a trigger?(weblogs.sqlteam.com)

submitted by spirit1spirit1(3160) 4 years, 10 months ago

The most popular method of auditing data is with an AFTER DELETE, INSERT, UPDATE trigger. But what happens if you have a Rollback statement in your trigger if some condition is met? <br><br> More ><a href="http://weblogs.sqlteam.com/mladenp/archive/2007/04/13/60174.aspx">here</a>

add a comment |category: |Views: 7

tags: another

new Add a live kick counter to your blog >> liveImage

You can even customize the image by choosing your own colors, and then clicking the button below to update the preview and the html code:

  • "Kick It" text
  • "Kick It" background
  • kick count text
  • kick count background
  • border

Simply copy and paste this HTML into your blog post.


Users who kicked this story:
spirit1spirit1(3160)
Comments:

No comments so far

information Login or create an account to comment on this story
Submit a Story
View upcoming stories
How else can I help?
Add our feeds to your site

Most Active Users

What's this?