Author
Cannot drop database “xxxxx” because it is currently in use.
Problem: Solution: When you have tried everything to drop the database but nothing works. Stop the SQL Server service. Manually remove the data files from drive. Restart the SQL Server service. Delete database.
TeamCity
TeamCity is a build management and continuous integration server from JetBrains. It was first released on October 2, 2006 and is commercial software and licensed under a proprietary license: a freemium license for up to 100 build configurations and three free Build Agent licenses are available. https://www.jetbrains.com/teamcity/
Custom CommandExecute Script
https://ola.hallengren.com
Custom Index Optimizer Script
Source: https://ola.hallengren.com User Database IndexOptimize Script
Custom Database Integrity Check Script
Source: https://ola.hallengren.com Database Integrity Check: System Database Database Integrity Check: User Database DatabaseIntegrityCheck Script
Custom Backup Database with Script
Source: https://ola.hallengren.com Backup: SYSTEM FULL Backup: USER FULL Backup: USER DIFF Backup: USER LOG [dbo].[DatabaseBackup] Script
Add Table Logging to Stored Procedure
Create table to store log data. Create stored procedure to insert data into log table. Add logging to user stored procedure. dbo.tbMyLog.sql dbo.uspInsertMyLog.sql Logging in uspMySP01 Remove log entries older than 1 month