emptying database

emptying database

am 22.10.2007 14:27:40 von Phung

Hi friend ! is there anyway to erase the whole content of a database
other than executing the script.

Re: emptying database

am 23.10.2007 13:37:04 von mooregr_deleteth1s

"Phung" wrote in message
news:1193056060.280220.235250@e9g2000prf.googlegroups.com...
> Hi friend ! is there anyway to erase the whole content of a database
> other than executing the script.
>

You could drop and recreate the DB.



--
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html

Re: emptying database

am 23.10.2007 14:37:36 von Jack Vamvas

If you are dropping and recreating , don't forget to take a script backup of
the db

--

Jack Vamvas
___________________________________
Search IT jobs from multiple sources- http://www.ITjobfeed.com




"Phung" wrote in message
news:1193056060.280220.235250@e9g2000prf.googlegroups.com...
> Hi friend ! is there anyway to erase the whole content of a database
> other than executing the script.
>