BrentOzarULTD / SQL-Server-First-Responder-Kit

sp_Blitz, sp_BlitzCache, sp_BlitzFirst, sp_BlitzIndex, and other SQL Server scripts for health checks and performance tuning.
http://FirstResponderKit.org
Other
3.38k stars 1k forks source link

Installing sp_DatabaseRestore produces a ton of warnings about CommandExecute #3499

Closed BrentOzar closed 7 months ago

BrentOzar commented 7 months ago

Version of the script SELECT @Version = '8.19', @VersionDate = '20240222';

What is the current behavior? If you install the Blitz scripts on a server that doesn't have Ola's CommandExecute, you get a wall of warnings: Screenshot 2024-04-19 at 9 33 40 AM

I can't suppress that, but at the beginning of the sp_DatabaseRestore creation script, I can put a check for CommandExecute, and at least explain that if they're going to use sp_DatabaseRestore, they need Ola's scripts first.