SQL Table Question

[ashishsmith]

I have question regarding SQL Tables. I update my tables by DTS packages every Friday morning. These are millions of data, there is no way I can compare the new data and the old data manually because most of them are same.

I have 2 things to ask,

• How to see the last modified date of the SQL Table, so that i know it was modified?

• Another one is, I want to compare table with old data and table with new data, if the data is same than it should email me so that i can go and check whats going on. If they are different than it should just update the table with old data to the new data.

I wish its not too complicated and would be easy to answer.

Thank you for your support in advance.

Ashish Smith

 

[dbomrrsm]

thread183-899879

might get you started

[blue]DBomrrsm[/blue]