Knowledge Base

BUG: Msg 229 on UPDATETEXT If Source Table Lacks Permission

Article ID: 192963

Article Last Modified on 10/3/2003

Microsoft SQL Server 6.5 Standard Edition

This article was previously published under Q192963

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: kbbug KB192963