Click or drag to resize

SA0206 : The sp_configure store procedure executed with a deprecated option

The topic describes the SA0206 analysis rule.

Message

The sp_configure store procedure executed with a deprecated option

Description

The rule checks T-SQL code for EXECUTE statements of the sp_configure stored procedure, where the configuration option is for a deprecated feature,

These deprecated features options configuring feature is in maintenance mode and may be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.

The following options are deprecated:

- 'allow updates'

- 'locks'

- 'open objects'

- 'set working set size'

- 'priority boost'

- 'remote proc trans'

- 'c2 audit mode'

- 'default trace enabled'

Scope

The rule has a Batch scope and is applied only on the SQL script.

Parameters

Rule has no parameters.

Remarks

The rule does not need Analysis Context or SQL Connection.

Categories

New Rules, Deprecated Features

Additional Information
Example Test Script
SQL
 1sys.sp_configure @configname ='allow updates'
 2
 3USE AdventureWorks2012;
 4
 5DECLARE  @result INT
 6EXEC @result = dbo.uspGetWhereUsedProductID  819, '20050225';
 7
 8EXECUTE  dbo.uspGetWhereUsedProductID  819, '20050225';
 9EXEC sp_configure 'show advanced options', 1;  
10EXECUTE sp_configure @configname ='allow updates'
11EXECUTE   sp_configure 'locks', 20000;  
12EXEC sp_configure 'open objects' , 20000
13
14EXEC sp_configure 'set working set size', 123
15
16EXEC sp_configure @configname ='priority boost', 1 ;  
17EXEC sp_configure 'remote proc trans', 1
18EXEC sp_configure @configname = 'c2 audit mode',1
19
20EXEC sys.sp_configure @configname = 'default trace enabled', 1
21
22EXEC sp_configure @configname = 'some other option'

Analysis Results

 MessageLineColumn
1SA0206 : This option is still present in the sp_configure stored procedure, although its functionality is unavailable in SQL Server. The setting has no effect.130
2SA0206 : This option is still present in the sp_configure stored procedure, although its functionality is unavailable in SQL Server. The setting has no effect.1034
3SA0206 : The configudation option is now automatically configured. Setting has no effect.1123
4SA0206 : This option is still present in the sp_configure stored procedure, but its functionality is unavailable in Microsoft SQL Server.1218
5SA0206 : This option is still present in the sp_configure stored procedure, but its functionality is unavailable in Microsoft SQL Server.1418
6SA0206 : The priority boost option is deprecated. Use the Windows start /high … program.exe option instead.1631
7SA0206 : The remote proc trans option is deprecated.1718
8SA0206 : The c2 audit mode option is deprecated. Use common criteria compliance enabled option instead.1832
9SA0206 : The default trace enabled option is deprecated and may be removed in a future version of Microsoft SQL Server. Use Extended Events instead.2036
See Also

Other Resources