/*
here is a little script I've hobbled together that I use to get version and license info for a Red Gate install
enjoy,
Chuck
*/
DECLARE @version nvarchar(32) DECLARE @edition int DECLARE @SerialNumber VARCHAR(30);
exec master..sqbutility 21, @edition OUTPUT, @version OUTPUT, @SerialNumber OUTPUT;
SELECT SERVERPROPERTY('MachineName') as "HOST", SERVERPROPERTY('InstanceName') as "SQL INSTANCE",@version as "RED GATE VERSION", @SerialNumber as "RED GATE LICENSE NUMBER", @edition as "RED GATE EDITION CODE", '0 = Trial: Expired | 1 = Trial | 2 = Standard | 3 = Professional | 6 = Lite' as "EDITION CODE MEANINGS"
