I was orginally having trouble accessing stored procedures with CF7.0 & MSSQL
2000 SP4. Random script code would error out on Application.cfc & other pages
trying to retrieve information from a store procedure. Part of the problem was
SQL 2000 was not orginally updated to SP4 which fixes some problems. I had to
changed my database connection type.

Orginally I was using a ODBC Socket trusted connection which was configured
thorough Windows 2003 Server Contol Panel using the Data Sources applet. I
replaced this connection with a MS SQL Server Driver in cfide/administrator
using SQL login account.

Now I'm not having any more wierd errors. The errors I would get was 07009 =
Invalid Descriptor Index and HY000 = lnternal Error at <cfprocresult
name="Menus"> in the Application.cfc

<cfstoredproc procedure="p_Select_AppMenuBuilder"
datasource="#Application.DB#" returncode="no">
<cfprocparam type="In" cfsqltype="CF_SQL_VARCHAR" variable="@page"
value="#Url.page#" maxlength="50" null="no">
<cfprocparam type="In" cfsqltype="CF_SQL_VARCHAR" variable="@username"
value="#Session.Username#" null="no">
<cfprocresult name="Menus">
</cfstoredproc>
<cfloop query="Menus">
<cfset request.AppMenu = request.AppMenu & "<li><a href=""" & Application.Url
& Session.Template & "?page=" & appID & """>" & "<img
src=""images/line_slim2.gif"" border=""0"" align=""absmiddle""
alt=""Arrow"">&nbsp;" & AppName & "</a></li>">
</cfloop>