Search code examples
azure-synapse

Azure Synapse Serverles Pool Database Error: Cannot drop database "DataverseEnriched" because it is currently in use

I am attempting to delete/drop a SQL Database created in from Azure Synapse Serverless Built-in Pool, but I keep on getting the error:

Error message: 'Failed to execute query. Error: Cannot drop database "" because it is currently in use. '. Tracking id: '3742517f-6b04-4b48-99e9-a1626d07ad8d'.

Any thoughts on why I'm getting error, and how to drop the database?

Now, when issue the following code:

USE [master];  
GO  
DROP  DATABASE [DataverseEnriched]; 
GO

I get the following output

enter image description here

Solution

  • enter image description here

    Use Master in Microsoft SQL Server Management Studio and run below command on Azure UI portal. DROP DATABASE [Database Name] GO