INF: sp_dbcmptlevel 'master' is not Allowed (214602)


The information in this article applies to:

  • Microsoft SQL Server 7.0
  • Microsoft SQL Server 2000 (all editions)
This article was previously published under Q214602

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.
Modification Type:MajorLast Reviewed:10/17/2003
Keywords:kbinfo KB214602
©2003 Microsoft Corporation. All rights reserved.