How to find out what version of SQL Backup is installed

matt.stanford · January 17, 2008 10:42AM

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 · January 17, 2008 11:50AM

Try this:

DECLARE @value varchar&#40;32&#41;
EXEC master..sqbutility 1030, @value OUTPUT
SELECT @value

HJoyce · January 17, 2008 11:50AM

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 · January 17, 2008 11:52AM

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

How to find out what version of SQL Backup is installed

Comments

Product Learning

Community Forums

Events & Friends

Simple Talk