How can we help you today? How can we help you today?

How to find out what version of SQL Backup is installed

I'm trying to figure out how to programmatically query for the correct version of SQL Backup.

My end goal is that I want to automatically fire off some TSQL when the version is X.

Is there a way to do this without using the GUI?

Any help would be appreciated.

-Matt
matt.stanford
0

Comments

3 comments

  • petey
    Try this:
    DECLARE @value varchar(32)
    EXEC master..sqbutility 1030, @value OUTPUT
    SELECT @value
    
    petey
    0
  • HJoyce
    To get the version of the SQL Backup Extended Stored Procedure DLL you can use the following command:

    execute master..sqbutility 30, @CurrentDLLVersion OUTPUT;

    To get the version of the SQL Backup Service you can use:

    execute master..sqbutility 1030, @CurrentSrvVersion OUTPUT;
    HJoyce
    0
  • matt.stanford
    Wow, two answers at the same time. Thanks to both of you.

    I just ran that code and it's exactly what I was looking for.

    -Matt
    matt.stanford
    0

Add comment

Please sign in to leave a comment.