![]() Here is the stored procedure: ALTER PROCEDURE. ![]() Everything works fine if I have a small query in just the first parameter or if I split it into two, butįor some reason when my first parameter is past 2900 characters it blowsup when it should be able to accept up to 8000. The problem is that the string that it is complaining about is less than 8000 characters. template 14044 meta 13909 icons 13760 line 13673 children 13410 featured. The error is telling you that you have a line of code that is too long for it to handle. Size and the 8000 character parameter limitation. The error message should tell you approximately which line is causing the error (typically the line before the line number in the message). I am sending the query in 3 parts to avoid the 8000 nvarchar max Hello, I am using a web app to send a query string to a stored procedure that uses OPENROWSET to query my database with the specified query and then display the information in a report. 1329,quired:1330,pop:1331,length:1332,image:1333,work:1334.
0 Comments
Leave a Reply. |