|
sql
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Possible workarounds known bug 472098 for error when passing large text parameter (>64 MB) to storedissue, this is on Sql Server 2000 sp3. Turned out to be a known bug 472098. We were getting an error from the .Net provider on the client who was calling a stored procedure, passing in a text parameter of about 80 MB: System.Data.SqlClient.SqlException: General network error. Check your network documentation. ConnectionWrite (send()). ..Net SqlClient Data Provider In the Sql Server log we were getting: "WARNING: Failed to reserve contiguous memory of Size= 65536." The work around to increase the memory in the MemToLeave area using the -g startup parameter alleviated the issue by allowing us to pass in larger blocks of text. The details of the support ticket are included below for any of those who are interested: Microsoft Support Incident SRX050225607222 ======================================================================= Problem Description: ======================================================================= Passing a ntext parameter to a stored procedure results in 17883 errors. Cause: ======================================================================= You were hitting a known bug (472098) which is supposed to be resolved by SP4. Resolution: ======================================================================= I suggested you two alternatives: 1. Wait for SP4 to be released to see if the issue is resolved by SP4 (not likely). 2. use -g512 in the startup parameters of the SQL Server to alleviate the issue. In Conclusion: ======================================================================= Your issue was resolved temporarily using the second option. Please go through the following links as these might be related to your issue: You may receive a 17883 error message when you run full-text queries in SQL Server 7.0 or SQL Server 2000 http://support.microsoft.com/default.aspx?scid=kb;en-us;888666 High-end disk subsystems may experience error 17883 http://support.microsoft.com/default.aspx?scid=kb;en-us;810885 New concurrency and scheduling diagnostics added to SQL Server http://support.microsoft.com/default.aspx?scid=kb;en-us;319892 INF: Use Trace Flag 3505 to Control SQL Server Checkpoint Behavior http://support.microsoft.com/default.aspx?scid=kb;en-us;815436  |
|||||||||||||||||||||||
Other interesting topics