INF: sp_dbcmptlevel 'master' is not Allowed

ID: Q214602

The information in this article applies to:

Microsoft SQL Server version 7.0

SUMMARY

Setting the compatibility level of the master database is not allowed. The master database must always be in SQL 7.0 compatibility level.

MORE INFORMATION

If you attempt to put the master database into a different compatibility mode by running the following:


exec sp_dbcmptlevel 'master', 65

You will get this error:

Server: Msg 15417, Level 16, State 1, Procedure sp_dbcmptlevel, Line 80 Insufficient permission to change the compatibility level of the 'master' database.

Even logged on with the 'sa' account fails to put the master database in an alternate compatibility mode. Do not attempt to do this.

Additional query words:

Keywords : kbSQLServ700
Version : winnt:7.0
Platform : winnt
Issue type : kbinfo