Wednesday, 29 November 2017
Drop failed for Database "Demo" or Cannot drop database "Demo" because currently in Use in Sql Server.
in: sqlserver
In this article, We Will discuss about Drop failed for Database "Demo" or Cannot drop database "Demo" because currently it is in Use.
Whenever we are deleting any Database then at Sometime Drop failed for Database "Demo" or Cannot drop Database "Demo" arises because whenever Someone is using that Database then directly you can't able to delete that Database Which is Shown in below image.
Solution
----------
To Resolve this error We need to Just Check the "Close existing connections" Checkbox and again Click Ok. After that the Database Will be deleted Which is Shown in below image.
RELATED POSTS

Formatting of numbers by leading zeros in SQL Server.
In this article, We will discuss How to format of numbers by leading Zer ...

Difference between Varchar and NVarchar in Sql Server.
-Varchar stands for Non-Unicode Variable length character data type where ...

Error converting varchar to numeric in Sql Server.
In this article, We will discuss Why "Error converting varchar to numeri ...

Expression type int is invalid for COLLATE Clause in Sql Server
Moved this article to Expression type int is invalid for COLLATE Cl ...
-
This issue is Completely related to EntityFramework and this issue arises whenever you have installed EntityFramework in one project at th...
-
This is generally a Common Problem or the error could be like this, To Resolve this error, One Small Solution is Exists which is as b...
-
In this article, We will discuss What is the above Error and How to resolve this Error. Whenever, We are Restoring our database into A...
0 comments:
Post a Comment