Reporting version number on SQL Backup Pro
Just a quick update to share a piece of handy information. Red Gate does not document it in their help files, but there is a way to get the version number of the Red Gate DLL used to create backups with T-SQL with the following query:
DECLARE @version nvarchar(32)
DECLARE @edition int
exec master..sqbutility 21, @edition OUTPUT, @version OUTPUT
SELECT @version
Quite handy if you're doing a survey on what versions of SQB are in use in your SQL environment.