
-> Below is the view of the databases on Azure Synapse Analytics on SQL Server Management Studio ,

-> I was trying to drop jbdw_restore_29March2021 from SQL Server management studio and got below error,
TITLE: Microsoft SQL Server Management Studio
Drop failed for Database ‘jbdw_restore_29March2021’. (Microsoft.SqlServer.Smo)
For help, click: https://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=16.100.41011.9+(SqlManagementObjects-master-APPLOCAL)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Drop+Database&LinkId=20476
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
Statement ‘Drop Database’ is not supported in this version of SQL Server. (Microsoft SQL Server, Error: 104454)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&ProdVer=12.00.2531&EvtSrc=MSSQLServer&EvtID=104454&LinkId=20476
BUTTONS:
OK

-> Open Azure portal and navigate to required Dedicated SQL pool,

-> On the Overview Tab. Click Delete,


-> Click on “Delete”,


-> Below is the view of the databases on Azure Synapse Analytics on SQL Server Management Studio,

Thank You,
Vivek Janakiraman
Disclaimer:
The views expressed on this blog are mine alone and do not reflect the views of my company or anyone else. All postings on this blog are provided “AS IS” with no warranties, and confers no rights.