SA0205 : The backward compatibility views for SQL Server 2000 system tables are deprecated. Use the current SQL Server system views instead

The topic describes the SA0205 analysis rule.

Message

The backward compatibility views for SQL Server 2000 system tables are deprecated. Use the current SQL Server system views instead

Description

The rule checks for usage of the backward compatibility views for SQL Server 2000 system tables.

This backward compatibility views will be removed in a future version of Microsoft SQL Server.

How to fix

Avoid using this feature in new development work, and plan to modify applications that currently use this feature.

It is recommend that you use the current SQL Server system views instead.

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.

Effort To Fix
20 minutes per issue.
Categories

Deprecated Features, Bugs

Additional Information
Example Test SQL
SQL
1select * from sysservers
2
3select * from sys.sysservers
4select * from someTable

Analysis Results
  Message Line Column
1 SA0205 : The backward compatibility views for SQL Server 2000 system tables are deprecated. Use the current SQL Server system views instead. 1 14
2 SA0205 : The backward compatibility views for SQL Server 2000 system tables are deprecated. Use the current SQL Server system views instead. 3 18
See Also

Other Resources