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

ID: Q197389

The information in this article applies to:

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.

MORE INFORMATION

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

STATUS

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

Additional query words: err 

Keywords          : SSrvStProc kbbug7.00 
Version           : WINNT:7.0
Platform          : winnt
Issue type        : kbbug
Solution Type     : kbpending

Last Reviewed: December 16, 1998