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

ID: Q197389

The information in this article applies to:

Microsoft SQL Server version 7.0

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 : SSrvStProc kbbug7.00
Version : winnt:7.0
Platform : winnt
Issue type : kbbug