Auditing data changes

Great post about using the output command to capture data changes when running update statements.  A nice alternative when backing up the entire table isn’t that great of an option.

http://www.sqlservercentral.com/blogs/sqlstudies/2013/06/26/using-output-to-back-up-a-change/

Advertisements
This entry was posted in Database Administration and tagged , , , , , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s