bo/@Database/bo_clear_data.sql

USE [BO]
GO

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