C# Tutorials and offshore development in India
    Tutorials   Resources   Forum   Communities   Interview   Jobs   Projects   Offshore Development    
Silverlight Tutorials | Mentor | Code Converter | Articles | Code Factory | Computer Jokes | Members | Peer Appraisal | IT Companies | Bookmarks | Revenue Sharing |


Prizes & Awards
My Profile



Active Members
TodayLast 7 Days more...

New Feature: Community Sites: Create your own .NET community website and start earning from Google AdSense ! It's Free !




Cannot drop database


Posted Date: 25 Jun 2008    Resource Type: Errors and Solutions    Category: General
Author: http://dotnetvj.blogspot.comMember Level: Diamond    
Rating: Points: 4



Error:
Cannot drop database “DataBaseName” because it is currently in use.
Solution:
Close SQL Server Management Studio completely. Open it again and connect as normal. Now you will be able to drop the database with

USE master
GO
DROP DATABASE (databaseName)
GO




Responses

Author: Bunty    29 Jun 2008Member Level: Diamond   Points : 2
Hi,

Very nice piece of information on dropping a database.

Short and simple to understand.

Keep posting such valuable tips.

Thanks and Regards
S.S.Bajoria


Author: Sunil Preetham    29 Jun 2008Member Level: Bronze   Points : 0
Hi ..............Very Nice........Keep Sharing


Author: Anand    30 Jun 2008Member Level: Bronze   Points : 1
Right click on the Database that u want to delete and select the delete option than Check Option(Close the Existing connections
and then press oK


Author: want2no    17 Jul 2008Member Level: Bronze   Points : 0
ALL task >> Detach database.


Author: Prafulla S Shimpi    11 Sep 2008Member Level: Gold   Points : 1
Nice one,

but before that make sure that none of the sessions (either internal or external-through fron end) are open for the database.

otherwise, user may lose the data / work he/she currently doing.

either it should get committed or rolled back


Feedbacks      
Popular Tags   What are tags ?   Search Tags  
(No tags found.)

Post Feedback


This is a strictly moderated forum. Only approved messages will appear in the site. Please use 'Spell Check' in Google toolbar before you submit.
You must Sign In to post a response.
Next Resource: 'Problem in Connecting Database
Previous Resource: IE security Warning Against Running Scripts or ActiveX controls
Return to Discussion Resource Index
Post New Resource
Category: General


Post resources and earn money!
 
Related Resources



dotNet Slackers   BizTalk Adaptors    Web Design


Contact Us    Privacy Policy    Terms Of Use