How to find out what version of SQL Backup is installed

matt.stanford

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

petey

Try this:

DECLARE @value varchar(32)
EXEC master..sqbutility 1030, @value OUTPUT
SELECT @value

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;

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