Information générale
Forum:
Microsoft SQL Server
Versions des environnements
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!
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement