Microsoft KB Archive/214602

= INF: sp_dbcmptlevel 'master' is not Allowed =

Article ID: 214602

Article Last Modified on 10/17/2003

-

APPLIES TO


 * Microsoft SQL Server 7.0 Standard Edition
 * Microsoft SQL Server 2000 Standard Edition

-



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.

Keywords: kbinfo KB214602

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.