General information
Forum:
Microsoft SQL Server
Environment versions
SQL Server:
SQL Server 2005
You need to truncate tables in the correct order. How log would it take to create a sp that would truncate all your tables?
>Yeah, but that complains when I have FK constraints set.
>
>>TRUNCATE TABLE will reset identity.
>>
>>>I use Red Gate SQL Data Compare to duplicate my production data to a testing database. Basically it's a DELETE followed by a bunch of INSERTs. However, it seems to not reset the identity PK. I keep getting this error:
>>>
>>>{"Violation of PRIMARY KEY constraint 'PK_ApplicationNote'. Cannot insert duplicate key in object 'PreApplication.ApplicationNote'.\r\nThe statement has been terminated."}
>>>
>>>I know I can go in and run a script to reset the identity, but I have to do that on every table every time I do this. Does anybody know of a way to avoid this? Or a global way to reset all identity columns?
>>>
>>>Thanks!
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only