search

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.37k stars 997 forks source link

sp_DatabaseRestore: allow enabling service broker on restore #3543

Closed lowlydba closed 4 months ago

lowlydba commented 4 months ago

Fixes #3532 by adding the ability to re-enable the service broker after restoring a database.

Additionally, capitalized a few data types for consistency and my VSCode settings trimmed trailing whitespace. I can roll these back if you want to keep the history of lines modified cleaner, otherwise I think its a good habit to remove these (~3kb smaller without them, including my additions)

BrentOzar commented 4 months ago

Also, just going forward, please don't make any changes for formatting or personal preferences. Other folks are working on the repo at the same time, and this introduces more merge conflicts that are a pain in the rear for us to fix & test. Thanks for understanding!