Mechanism to Track Database Changes

Question

Post reply

Mechanism to Track Database Changes

aspnewbie

Grasshopper

Points: 18
More actions
March 10, 2004 at 2:33 pm

#86255

I am running MS SQL Server 7. Is there a way to easily generate a list of any changes to the content in any fields in any tables in a database?

Viewing 9 posts - 1 through 8 (of 8 total)

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

ray_higdon SSCarpal Tunnel Points: 4589 More actions · Answer 1

Do you mean going forward or historically? You might look into a product by Lumigent called Log Explorer or Entegra.

Going forward you could work some magic with SQL Profiler.

------------

Ray Higdon MCSE, MCDBA, CCNA

Jeff W SSCertifiable Points: 5207 More actions · Answer 2

Easily...no

Log Explorer may be good.

In some of my databases where there are legal concerns I have triggers that keep track of content changes...who, when, and what.

"Keep Your Stick On the Ice" ..Red Green

Frank Kalis SSC Guru Points: 111183 More actions · Answer 3

There is no such thing as a free lunch.

If you want such feature, I guess you have to implemtent it yourself.

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

aspnewbie Grasshopper Points: 18 More actions · Answer 4

Thanks for the info. I was looking at a going forward basis. I'll have to check out that profiler product.

I would build something myself but (a) didn't want to reinvent the wheel if some mechanism already existed (b) there's quite a few tables involved so it would take some time and (c) I'm going on mat leave any day now so I don't think I'll be able to squeeze it in!

Jeff W - quoting red green - you Cdn?

Amit Jethva SSCarpal Tunnel Points: 4707 More actions · Answer 5

Try using BINARY_CHECKSUM

Binary_CHECKSUM Returns the binary checksum value computed over a row of a table or over a list of expressions. BINARY_CHECKSUM can be used to detect changes to a row of a table.

see BOL for example.

-- Amit

"There is no 'patch' for stupidity."

Download the Updated SQL Server 2005 Books Online.