blog community

Welcome to blog community Sign in | Join | Help
in Search

Bertrand Rohrbock

All things related to SQL Server administration

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.

Published Friday, October 26, 2007 1:51 PM by BertrandR

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

No Comments

Leave a Comment

(required) 
(optional)
(required) 
Submit
Powered by Community Server, by Telligent Systems