When I Try To Execute The Stored Procedure In Coldfusion, Then Not All Of The Information Is Returned

When I try to execute the stored procedure in ColdFusion, then not all of the information is returned. I'm running ColdFusion 9.0.1 w/ Hot Fix 2. I'm working with SQL Server 2008

Solution 1:

Try this:

1) Log in to your ColdFusion administrator

2) Click on "Data Sources" on the navigation menu (under Data & Services)

3) Click on your data source

4) Click on the "Show Advanced Settings" button at the bottom of the page

5) Check the box next to "CLOB"

I would bet the "Buffer" values in the next boxes are "4000" on your server.

The default is "64000", which may be a clue than I am off base here.