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