Yes we can reset the identity column means explicitly but if we don't want to reset it explicitly then SQL server don't reset explicitly. 2ndly what...
Yes the only unique column in the production table is identity. What I want to convey is that, let me explain the scenario with an example:table1 is...
its ok i got it but my production table has identity column which is autogenerated value when it gets deleted it does not start from the deleted id...
OK but I didn't pick your answer clearly. Let me repeat. Table1 is my history table, since table2 is production table and i don't want to have so...
Thanks. OK but what in your opinion is the solution to avoid duplicate values being coming into table1. Do you thin i should make the id in table1 as...
Hi, I am having sql server 2005 enterprise edition with sp3. I am running a job for archiving older data. The job first copy data from one table2 to...
Separate names with a comma.
