Viewing 2 posts - 1 through 2 (of 2 total)
To delete all the records in the database.
Here is a solution for my onde problems...
EXEC sp_MSForEachTable 'ALTER TABLE ? NOCHECK CONSTRAINT ALL'
GO
EXEC sp_MSForEachTable 'DELETE FROM ?'
August 2, 2006 at 7:49 am
#652805
Is there any chance I can create a clone of my database without the data?
August 1, 2006 at 11:01 am
#652609