Hi Team,
[code]
SELECT
@product_version = CONVERT(varchar(50), SERVERPROPERTY('PRODUCTVERSION'));
SET @autostat_legacy_behavior =
CASE
WHEN ( CONVERT(
smallint, LEFT(@product_version, CHARINDEX('.', @product_version) - 1)
)
) >= 14
OR EXISTS ( SELECT * FROM @trace_status WHERE
TraceFlag = 2371 AND Status = 1
) THEN 0
ELSE 1
END;
[/code]
After the latest update to Version 9.1.16.5356 there are a lot of tabs in between which are not intended and not adjustable.
Would be nice to fix it soon cause the entire code looks horrible now - thanks!
Torsten
@product_version = CONVERT(varchar(50), SERVERPROPERTY('PRODUCTVERSION'));
SET @autostat_legacy_behavior =
CASE
WHEN ( CONVERT(
smallint, LEFT(@product_version, CHARINDEX('.', @product_version) - 1)
)
) >= 14
OR EXISTS ( SELECT * FROM @trace_status WHERE
TraceFlag = 2371 AND Status = 1
) THEN 0
ELSE 1
END;