How to determine whether a database has been changed or not ?

Posted by Locksfree on Stack Overflow See other posts from Stack Overflow or by Locksfree
Published on 2010-03-24T12:08:27Z Indexed on 2010/03/24 12:33 UTC
Read the original article Hit count: 145

Filed under:
|
|
|

I have a need to determine if a database on a MS SQL Server has changed between two distinct moments.

The change can be structural or data-related and the check should be generic (i.e. independant of the structure of the database). Preferably, I'd like the check to be T-SQL based or with SMOs, not file based. I checked on MSDN but I haven't found anything relevant so far.

© Stack Overflow or respective owner

Related posts about database

Related posts about change