emptying database

Hi friend ! is there anyway to erase the whole content of a database
other than executing the script.
Phung [ Mo, 22 Oktober 2007 14:27 ] [ ID #1851316 ]

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
mooregr_deleteth1s [ Di, 23 Oktober 2007 13:37 ] [ ID #1852212 ]

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.
>
Jack Vamvas [ Di, 23 Oktober 2007 14:37 ] [ ID #1852214 ]
Datenbanken » comp.databases.ms-sqlserver » emptying database

Vorheriges Thema: Min() query - 5th level optimization
Nächstes Thema: delete database file on server -> sharing violation