BUG: Set FIPS_FLAGGER Fails to Warn of SELECT Extensions

ID: Q152393

The information in this article applies to:

Microsoft SQL Server version 6.5

SYMPTOMS

The SET FIPS_FLAGGER is intended to guard against the unintentional use of nonportable SQL extensions. CUBE and ROLLUP extensions have been added to SQL Server 6.5 and are not part of the FIPS 127-2 standard. A warning is not reported when a SELECT statement with such an extension is executed with the FIPS_FLAGGER option switched on. Failure to report this warning does not invalidate FIPS 127-2 compliance of SQL Server 6.5.

STATUS

Microsoft has confirmed this to be a problem in Microsoft SQL Server version 6.5. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

Keywords :
Version : 6.5
Platform : WINDOWS
Issue type :