Sorry for the late reply, been out all day.

In the sproc editor upon trying to save I get:
"Error 403: Invalid operator for data type. Operator equals add, type equals ntext"

If I put quotes (single or double) around @Notes is saves in the sproc editor, but bombs upon execution.

Thanks,
Jace

>What's the error that is being returned?
>
>-Mike
>
>>My app is such that every customer has their own database. Every select/delete/update sproc pulls the customer database name from the configuration table into a string and I build a big fat update string and EXEC (@tql1 + @tsql2) to fire it off. This is working great for the entire app until I try to update NTEXT fields in a table, I have spent hours messing around with this and can't seem to get this going. I figure a guru out there has already been there and done this before. Any help would be greatly appreciated...
>>
>>Here is a sample of what I'm trying to do:
>>
>>CREATE PROCEDURE UpdateCustomerNotes
>>(
>>@CustId INTEGER,
>>@Notes NTEXT
>>)
>>
>>DECLARE @fullpath NVARCHAR(100),
>> @tsql1 NVARCHAR(4000),
>> @tsql2 NVARCHAR(4000)
>>
>>-- This next variable is actually pulling the database name from another sproc from the configuration table of every customers associated database.
>>SET @fullpath = 'Customer_abc001_Data.dbo.'
>>
>>SET @tsql1 = 'Update ' + @fullpath + 'Customer SET [cust_notes] = ' + @Notes
>>SET @tsql2 = ' WHERE [cust_id] = ' + CAST(@CustId AS NVARCHAR)
>>
>>EXEC (@tsq1 + @tsql2)
>>
>>This whole thing works if the field is a nvarchar (usually I have to put single or double quotes around the @Notes var, but as soon as I changed the field to NTEXT in the table nothing works. I've tried everything, but having to have a dynamic database name seems to screw everything up since there always has to be some sort of a variable to handle what database/file to update.
>>
>>TIA !!!