0

I'd like to take a table, generate it's hash string, store it, then compare it at a later predefined time and see if it matches, if not take note of the modification time and store that with the new change date.

This is because I believe an on insert trigger would cause a bad slow down if a batch of over 5000+ insert statements is submitted. I move large amounts of data per day and other than having a column of smalldatetime with a default get date, I have certain tables I do not have permissions to change the schema of, so I don't have a way to determine the last changed date of.

Maslow
  • 17,665
  • 17
  • 96
  • 181

2 Answers2

0

You can use CHECKSUM on various fields to do this.

Miles D
  • 7,467
  • 5
  • 31
  • 35
0

Yes based on what I understand of what that does betelgeuce, that looks like what I was hoping for, is there a row-level version of this? or would I just put a where clause on this same statement?

Maslow
  • 17,665
  • 17
  • 96
  • 181