I have a table name TABLE 1 which has an ID column as an Identity field
In my customer scenario I need to make a backup of that table in a temporary table for later recovery.
The temporary table named Temp_Table1 is exact structure from TABLE 1
For that I am using :
INSERT INTO TempTable1
SELECT * from Table1
Then I get a warning about the identity field
Then I ahave add bedore the SET IDENTITY_INSERT to ON on my Temp_Table but still get a warning error
What is best bway to bakup table
serge Your knowledge is enhanced by that of others.
View Complete Post