How can I sent in a single sql statement a string with more than 30000 chars. I incresed "Packet size" prop from SQL Server to 35000, but no result.
Thanks.
Printable View
How can I sent in a single sql statement a string with more than 30000 chars. I incresed "Packet size" prop from SQL Server to 35000, but no result.
Thanks.
Hi
I don't know a solution for the packet size problem..
but i think you have a big problem with the database design..
such large queries sould be stored in the database as stored procedurs..
this will :
- Decrease network traffic.
- Increase DB performance as the Prcedure will be compiled and cached.
- Improve the readability of your application.
Send it through as a blob (use BlobToFile & FileToBlob, or stream methods) If you search here using those as keywords, you should find the correct code to do what you want.