Hi, Quick answer (might not be a quick solution):
Repeat steps 1,2,3,4,5 Do step 6, but give the column ID the IDENTITY property. The next step is air-code (I just delete SQL Server from my system so I can't check it right now): SET IDENTITY_INSERT TableName ON Do steps 7 and 8 as before. SET IDENTITY_INSERT TableName OFF HTH. Adelle. > Here's what I did with SQL: > > 1. Create a temporary table > 2. Insert values to the temporary table 3. Update the > temporary table 4. Alter the temporary table 5. Drop the > original table 6. Re-create the original table 7. Insert > values to the original table from the temporary table 8. Drop > the temporary table > > * When I recreated the original table, I removed the Identity > of the column ID to allow the insert from the temporary table. > > How do I restore the IDENTITY property of the column ID? ------------------------ Yahoo! Groups Sponsor --------------------~--> Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar. Now with Pop-Up Blocker. Get it for free! http://us.click.yahoo.com/L5YrjA/eSIIAA/yQLSAA/saFolB/TM --------------------------------------------------------------------~-> Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AspClassicAnyQuestionIsOk/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
