Blank CF Pages When using stored procedures

[bemall]

Environment:
Windows XP SP2, IIS, SQL 2005 and CFMX 7,0,2,142559 .

Issue: I have queries within the CFML pages coded using <cfquery>. Converting these to <cfstoredproc> leads to a blank cfml page with no errors in the exception, server or application log.
I ran a profiler trace on the database and I can see the stored proc getting executed but still get a blank page.
Executing an testing the queries in Management studio\query aalyzer works successfully.

Any ides on the cause of this.

[insuractive]

Check to make sure the account that CF is running under has permissions to access the stored procedure. I don't know about SQL2005, but previous versions of MS SQL would default store procedure permissions in a way that forced you to go in a manually check the permissions for the CF database account.

[bemall]

I ran a profiler trace on the database and I can see the stored proc getting executed but still get a blank page.

From the above the account has access to the SP

[paross1]

I don't see how anyone could really fully answer this without seeing your stored proc code (or your CFSTOPREPROC call for that matter)

Phil

[bemall]

Let me clarify. My CF pages are returning blank when I use stored procedures and or cfquery. So this is not just about one stored procedure or one sql statement or the syntax. My issue is with CF MX 7 returning blank pages. In CF MX 6 and CF 5, I would get an error message with the line number and offending page name. My debug settings is set to classic. Enable Robust Exception Information,General Debug Information,Database Activity ,Exception Information and Tracing Information are checked.
The only way I have been able to debug so far is by opening the application log and looking at the entries. This is slow and inefficient.

[insuractive]

I'm sure you've already checked this, but just to confirm, when you say a blank page - have you checked the HTML source code returned to make sure no error messages are for some reason not being displayed by your browser.