/* check current version of SQL Server */
set nocount on
DECLARE @currentVersion char(255)

select @currentVersion  = @@version

if ( charindex("6.50.201", @currentVersion) <> 0)
BEGIN
	PRINT "SQL Server 6.5 release version detected"
END

if ( charindex("6.50.213", @currentVersion) <> 0)
BEGIN
	PRINT "SQL Server 6.5 SP1 detected"
END

if ( charindex("6.50.240", @currentVersion) <> 0)
BEGIN
	PRINT "SQL Server 6.5 SP2 detected"
END

if ( charindex("6.50.258", @currentVersion) <> 0)
BEGIN
	PRINT "SQL Server 6.5 SP3 detected"
END

if ( charindex("6.50.281", @currentVersion) <> 0)
BEGIN
	PRINT "SQL Server 6.5 SP4 detected"
END