Microsoft KB Archive/197389

= BUG: MSG 15417 Trying to Change Compatibility Level of Master DB =

Article ID: 197389

Article Last Modified on 10/15/2002

-

APPLIES TO


 * Microsoft SQL Server 7.0 Standard Edition

-



This article was previously published under Q197389



BUG #: 52002 (SQLBUG_70)



SYMPTOMS
When a member of the System Administrators (sysadmin) role attempts to use the sp_dbcmptlevel stored procedure to change the compatibility mode of the master database, the following error message is returned:

Server: Msg 15417, Level 16, State 1, Procedure sp_dbcmptlevel, Line 80

Insufficient permission to change the compatibility level of the 'master' database.

This message implies that with sufficient permission, the compatibility level setting can be changed, which is not true.



STATUS
Microsoft has confirmed this to be a problem in SQL Server version 7.0.



MORE INFORMATION
The compatibility mode of the master database cannot be changed. It must always be set to 7.0.

Additional query words: err

Keywords: kbbug kbpending KB197389

-

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

© Microsoft Corporation. All rights reserved.