May 1, 2008 at 8:25 am
how to delete a database in sql 2000 and everything assocated with it
May 1, 2008 at 8:34 am
Drop Database [db_name].
I'm not sure what you mean by everything associated with it. As dropping the database drops everything in the database.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
May 1, 2008 at 9:24 am
I want to delete the whole database and the files on the server
May 1, 2008 at 9:33 am
That's what drop database does. If you use SSMS to do it, you are given the option of deleting backup files as well.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
May 1, 2008 at 9:54 am
Is SSMS... Enterprise Manager, I am sorry for sounding so inexperienced.....but I am not a DBA, I am a System Admin tasked with the job of Migrating one sql 2000 box to another and I am cleaning up the old DB's before I migrate.
Thanks for your help
May 1, 2008 at 10:03 am
Sorry you put the post in a SQL Server 2005 forum so I answered with a SQL Server 2005 application. SSMS replaced Enterprise Manager with SQL 2005. You would use Enterprise manager in SQL 2000. Right-Click the DB and select Delete.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
May 1, 2008 at 10:21 am
I'd do what Jack suggested.
moved to 2000 forums.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply