Lowell,

Now I understand about the Identity issue. So are you going to send me the codes how to update those 4 tables from Active to Archive database? I sent you...

Thanks Lowell for your quick responses..

The Databases are: Active_Client_data and Archive_Client_data. Both are in same server. Structurally, they are 100% identical with table's, SP's and Views. except table data's...

Thanks Lowell for your quick response..

I forgot to mention, I am using SQL 2005 and Both Active and Archive Databases are in the Same Server:

Database Names:

Active_Client_Data

Archive_Client_Data

And the Server Name is:...