FIX: DBO Unable to Alter Database Using Enterprise Manager

This article was previously published under Q246588
This article has been archived. It is offered "as is" and will no longer be updated.
BUG #: 56161 (SQLBUG_70)
If the owner of a database attempts to use Enterprise Manager to alter a database, the following SQL-DMO error occurs:
Error 22021: [SQL-DMO]You must be logged in as 'sa', or a member of sysadmin, or a member of dbcreator to perform this operation.
Use the ALTER DATABASE T-SQL command to alter the database instead.
Microsoft has confirmed this to be a problem in SQL Server 7.0. This problem has been corrected in U.S. Service Pack 2 for Microsoft SQL Server 7.0. For more information, click the following article number to view the article in the Microsoft Knowledge Base:
254561 INF: How to Obtain Service Pack 2 for Microsoft SQL Server 7.0 and Microsoft Data Engine (MSDE) 1.0
For more information, contact your primary support provider.

Article ID: 246588 - Last Review: 10/22/2013 02:54:04 - Revision: 2.1

Microsoft SQL Server 7.0 Standard Edition

  • kbnosurvey kbarchive kbbug kbfix KB246588