declare @can_compress int
set @can_compress=0 

if OBJECT_ID('sys.configurations') is not null
begin
  SET @can_compress =ISNULL(CAST((
      SELECT 1
      FROM sys.configurations
      WHERE [name] = 'backup compression default') AS int),0)
end

SELECT @can_compress

FROM sys.configurations
WHERE [name] = 'backup compression default'

select
 case
  when a.ProducVersion >= '1050'/*2008 R2*/ and a.EngineEdition in (2/*Standard*/, 3/*Enterprise*/) then 1
  when a.ProducVersion >= '1000'/*2008*/ and a.EngineEdition = 3/*Enterprise*/ then 1
  else 0
 end
from
 (
  select
   serverproperty('EngineEdition'),
   right('00' + parsename(cast(serverproperty('ProductVersion') as varchar(30)), 4), 2) + 
   right('00' + parsename(cast(serverproperty('ProductVersion') as varchar(30)), 3), 2)
 ) a(EngineEdition, ProducVersion);

select
   serverproperty('EngineEdition'),
   right('00' + parsename(cast(serverproperty('ProductVersion') as varchar(30)), 4), 2),
   right('00' + parsename(cast(serverproperty('ProductVersion') as varchar(30)), 3), 2),
serverproperty('ProductVersion')