Unable to Drop/Delete Database from Server

Use the following to drop the database…

USE master 
GO

ALTER DATABASE [TCS] SET OFFLINE WITH ROLLBACK IMMEDIATE
ALTER DATABASE [TCS] SET SINGLE_USER WITH ROLLBACK IMMEDIATE
DROP DATABASE [TCS]

If the above failed, do this…

• Stop the SQL Services. Kill the sqlserver.exe process on service if the services fail to stop.
• Manually delete the physical database files from the drives.
• Restart the SQL Services, then drop the database.