BUG: Msg 229 on UPDATETEXT If Source Table Lacks Permission

ID: Q192963

The information in this article applies to:

Microsoft SQL Server version 6.5

BUG #: 17709 (SQLBUG_65)

SYMPTOMS

If you use the UPDATETEXT statement to update text data in a table on which you have appropriate update permission, based on a text column from another table on which you do not have update permission, it will fail with the following message:

Msg 229, Level 14, State 1
UPDATE permission denied on object %.*s, database %.*s, owner %.*s

The table listed in the message will be the table you are reading the information from.

WORKAROUND

To work around this problem, perform the following steps:

Use SELECT..INTO to select data from the source table to a new table. You are the database owner (DBO) of this new table, and therefore have update permission on it.

Read data from this new table. Get the textpointer from this table to do the update.

STATUS

Microsoft has confirmed this to be a problem in SQL Server version 6.5.

Additional query words: error err

Keywords : kbbug6.50
Version : WINNT:6.5
Platform : winnt
Issue type : kbbug