emptying database
Hi friend ! is there anyway to erase the whole content of a database
other than executing the script.
Re: emptying database
"Phung" <purwa [at] purwadhika.com> wrote in message
news:1193056060.280220.235250 [at] 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
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" <purwa [at] purwadhika.com> wrote in message
news:1193056060.280220.235250 [at] e9g2000prf.googlegroups.com...
> Hi friend ! is there anyway to erase the whole content of a database
> other than executing the script.
>