SQL Server Reset Identity Increment for all tables
- by DanSpd
Basically I need to reset Identity Increment for all tables to its original.
Here I tried some code, but it fails.
http://pastebin.com/KSyvtK5b
actual code from link:
USE World00_Character
GO
-- Create a cursor to loop through the System Ojects and get each table name
DECLARE TBL_CURSOR CURSOR
-- Declare the SQL Statement to cursor through
FOR…