BUG: MSG 15417 Trying to Change Compatibility Level of Master DB (197389)
The information in this article applies to:
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.
| Modification Type: | Major | Last Reviewed: | 10/15/2002 |
|---|
| Keywords: | kbBug KB197389 |
|---|
|