October 2, 2007 at 10:03 pm
Comments posted to this topic are about the item Deleteing All Rows From Database
October 2, 2007 at 10:08 pm
That's a cool quick and dirty way to do this. However there's always the otion of scripting everything, then creating a new blank db. Both solutions work, it only depends on how urgently you need to wipe out that baby.
November 25, 2007 at 9:19 pm
Be good to see some mods to the script:
1) Check if the table can be truncated (no foreign keys etc) and use Truncate Table instead of delete if this is the case. [Delete logging may take a significant amount of time on large tables]
2) Check the recovery model of the database first and alter it to simple if not already in this state
November 28, 2007 at 11:36 pm
First, really appreciate of this script code.
Abhijit, am new to sql server and i know sql in application oriented only not in scripting side.
Could you please explain me how it works and where to run this script.
many thanks
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply