I'm sending notifications to a SQL stored procedure and the output is truncated at about 20 characters. My proc can take nvarchar(max) and I've tested to make sure it will take quite a bit of text.

I've tried setting the type (in VisualCron) to nvarchar max, auto, and also text. I've tried with both Validate on and off. I found a previous post that mentioned needing to set something in the server settings but the only thing I see there is Output settings: Limit Output to 2000 characters. I've tried increasing this but it won't go above 2000.

I'm running version 5.6.3-11 beta.

Thanks for any ideas on how to get the full output to my proc.

Please let us know more about your setup. Database, version and other settings.

---

Database: SQL 2005 9.00.4053.00 SP3 Standard Edition

This runs on a different machine from VisualCron but both can see each other, and are connecting fine. The procedure is a single insert line - I'm not doing any sort of work on the input - and into a brand new table. There are no constraints or relationships on this table.

I tried with both the ODBC and SQL Server connection strings.

The input string I'm getting for the error message (I'm trying to test error logging so intentionally causing the task to fail) is: "Exception in Task: Th"

In the Task Log it reads: "Exception in Task: The remote server returned an error: (401) Unauthorized"

I've also tried to set the output to 500 characters in the sql notification parameters for my stored proc (in visualcron).

What other information would be helpful?

Can you please try to do the same in an SQL Task to see if that works?

---

Hi,

I found that a SQL Task does give the correct output - for example I used a very long name and it came through correctly.

Also I tried passing plain text back instead of a variable from my SQL Notification and that came through just fine (much greater than 20 chars), so it seems it is the variable that is being truncated not the output.

I had a similar problem - see http://www.visualcron.co....aspx?g=posts&t=1548 . It looks like "variables" in stored procedure parameters get expanded, but then get truncated back to the length of the original formula. For example:

"(TASK(Active|Result)}" - 21 characters
"Exception in Task: Th" - 21 characters

As a workaround you can append a load of space characters to the forumla for the parameter in the task, and then LTRIM(RTRIM(x)) the value when it gets to your stored procedure.

We are looking at this now.

---