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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy