Error on Clustered Index and NText Field

Hi i have a problem whenever i try to update a table in which i have a clustered index and a ntext field i have this error through a ASP page

Microsoft OLE DB Provider for SQL Server (0x80040E14)
The query processor could not produce a query plan from the optimizer because a query cannot update a text, ntext, or image column and a clustering key at the same time.

ThanksMay be you are trying to update more then one recond in query.

BOL:

If an update query could alter more than one row while updating both the clustering key and one or more text, image, or Unicode columns, the update operation fails and SQL Server returns an error message.

Modifying a text, ntext, or image column with UPDATE initializes the column, assigns a valid text pointer to it, and allocates at least one data page unless updating the column with NULL.

Note The UPDATE statement is logged. If you are replacing or modifying large blocks of text, ntext, or image data, use the WRITETEXT or UPDATETEXT statement instead of the UPDATE statement. The WRITETEXT and UPDATETEXT statements (by default) are not logged.|||i only have this error when i try to update the ntext field and the data is > than 10 KB...
Any idea and how could i use the updatetext in a asp SCRIPT?
Thanks again

Error Message when accessing Report Manager

Whenever I try to access Report Manager, I get this message. I don't know what caused it. I recently installed Crystal Reports v11 & Oracle 10gEX evaluation apps. Could they have caused this? How do I fix this?

Product:SQL Server Reporting ServicesEvent ID:rsReportServerDisabledSource:Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings.resources.StringsVersion:8.00Message:Unable to encrypt or decrypt data managed by the Report Server instance. Please refer to the Reporting Services online help for guidance in enabling this functionality.

Explanation

A symmetric key is a single key used to encrypt and decrypt data. Reporting Services encrypts the symmetric key itself, using the public key of a specific user account on a specific computer. This error occurs when the public key that the user account provides does not match the public key that report server is expecting. Conditions that cause this error to occur include changing the name of a report server instance, moving the report server instance to a different computer, or changing the account under which the Report Server service runs.

User Action

A system administrator on the computer running the report server service can use a backup copy of the public key to get the report server running again. Use the rskeymgmt utility to apply the backup key set. If you do not have backup of the key, you must run the rskeymgmt utility to delete all of the encrypted content, run the rsconfig utility to respecify the encrypted connection values used to connect to the report server database, restart the service, and retype stored credentials for all reports that use stored credentials. For more information this utility, search Books Online.

---

The encryption keys are tied to the service account user. If any of those programs reset the ASP.Net account, it would cause this error.

Have you tried following the steps listed under "User Action"? Depending on which accounts were reset, you might be able to use rsactivate -r if you do not have a backup key.|||Brian:

Pardon my lack of knowledge but exactly how does one access the "rsactivate -r". Do I type this into the "run" text block?

I have found the rskeymgmnt.exe & rsconfig.exe files. Rvery time I click the executable the command window pops open & immediately closes.

I apologize for asking such elementary questions but it is difficult to get answers outside of the expert forums.

Thanks, Jack|||Brian:

Can you tell me how to retrieve a backup key? I default installed SQL Server 2000 and later Reporting Services. I do not recall setting up a backup key. Can I use rekeymgmt -e to extract a key to a text file? Can I use rekeymgmt -a to apply it before I try to get into Report Manager?

When you say "any of those programs reset the ASP.Net account", I assume you are referring to either Oracle Express or Crystal Reports?

Do I type rsactivate -r into the "run" text box? Do I type any other characters with it? Do i need to type a specific account name with the reset commandor will a generic "rsactivate -r" reset all.

I am obviously a beginner. I would appreciate the help.|||Rsactivate and rskeymgmt are command line tools. You will want to open a command window and run the programs from there. You can run rsactivate /? and rskeymgmt /? to get more help on other flags you will need. Also see the MSDN documentation at http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsuiref/htm/cpu_rsconfig_v1_6yqq.asp and http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsuiref/htm/cpu_rsconfig_v1_29ly.asp for example usage and a description of what the various flags do.