sp_RestoreScript v1.4 – It’s Now Compatible with Case Sensitive Collations, Accepts Wild Cards in DB Names and Fixes A bug

sp_RestoreScript 1.4 is now out and ready for download from our GitHub, https://github.com/SQLUndercover/UndercoverToolbox/blob/master/sp_restorescript.sql

Full documentation on sp_RestoreScript can be found at https://sqlundercover.com/2017/06/29/undercover-toolbox-sp_restorescript-a-painless-way-to-generate-sql-server-database-restore-scripts/

New Features

Compatible with case sensitive collations

Now accepts wild cards in the @DatabaseName string, (‘Database1,Database2,SQL%’) would now be a valid option with % treated as a wildcard.

Bug Fixes

An issue when using multiple database and @no_recovery = 0 or @standby=1 would leave databases in NO_RECOVERY has now been fixed.