| 1234567891011 |
- EXEC sp_msforeachtable "ALTER TABLE ? NOCHECK CONSTRAINT all"
- GO
- EXEC sp_msforeachtable "DELETE FROM ?"
- GO
- EXEC sp_msforeachtable "ALTER TABLE ? WITH CHECK CHECK CONSTRAINT all"
- GO
- EXEC sp_msforeachtable "DBCC CHECKIDENT('?', RESEED, 1)", @whereand="and Schema_Id=Schema_id('dbo') and not o.Name in ('UserWorkspace','MetadocumentTag','MetadocumentBilling')"
- GO
|