Microsoft KB Archive/140717

{|
 * width="100%"|

BUG: Unsuccessfully Renamed User Table Shows in SEM

 * }

Q140717

-

The information in this article applies to:


 * Microsoft SQL Server version 6.0

-

BUG# NT: 11990 (6.00)

SYMPTOMS
When the SA or DBO attempts to rename a user-owned table in SQL Enterprise Manager (SEM), the rename fails with an error 15009:

The object '%s' does not exist in database '%s'

and the table name is not changed in sysobjects. However, the new table name is shown in the EDIT Table/Manage Tables option. If the new table is selected from the drop-down list box, an error 21770 occurs:

The name '%s' was not found in the specified collection)

WORKAROUND
Impersonate the table owner using SET USER in order to rename the tables.

-or-

Sign on as the user rather than SA or DBO in the user database and rename the tables.

STATUS
Microsoft has confirmed this to be a problem in Microsoft SQL Server version 6.0. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

Additional query words: sql6 winnt user

Keywords : kbtool

Issue type : kbbug

Technology : kbSQLServSearch kbAudDeveloper kbSQLServ600