Competition: What’s your favorite Redgate tool? Enter now.

How to get sql backup version using tsql?

ogrishmanogrishman Posts: 78 Bronze 4
edited July 28, 2010 3:00AM in SQL Backup Previous Versions
Hi guys,

How can I get the version of SQL Backup server component using TSQL?

Thanks.

Comments

  • peteypetey Posts: 2,358 New member
    DECLARE @edition INTEGER
    DECLARE @version VARCHAR(16)
    EXEC master..sqbutility 1021, @edition OUTPUT, @version OUTPUT
    SELECT @version
    
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
Sign In or Register to comment.