Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- EXEC sp_MSForEachTable 'DISABLE TRIGGER ALL ON ?'
- GO
- EXEC sp_MSForEachTable 'ALTER TABLE ? NOCHECK CONSTRAINT ALL'
- GO
- EXEC sp_MSForEachTable 'DELETE FROM ?'
- GO
- EXEC sp_MSForEachTable 'ALTER TABLE ? CHECK CONSTRAINT ALL'
- GO
- EXEC sp_MSForEachTable 'ENABLE TRIGGER ALL ON ?'
- GO
Add Comment
Please, Sign In to add comment