First, the debug option is awesome. It will help me fix some Active Directory issues. This is what I receive on the time out:
select GroupID from [dbo].[odr71_uggroups] where Label in ('ESE.CO.Admin','ESE Staff.ESE.CO.Admin','Dist.ESE.CO.Admin','Dist.Departments.CO.Admin','Domain Users','macg')
select TableName,AccessMask from [dbo].[odr71_ugrights] where GroupID in (1)
SELECT [dbo].[ODR_v2].[StudentID], [dbo].[ODR_v2].[Incident_Date], [dbo].[ODR_v2].[ID], [dbo].[ODR_v2].[Incident_Time], [dbo].[ODR_v2].[Describe_Behavior], [dbo].[ODR_v2].[Parent_Contact], [dbo].[ODR_v2].[Parent_Contact_Date], [dbo].[ODR_v2].[Parent_Contact_Detail], [dbo].[ODR_v2].[Action_Recommended], [dbo].[ODR_v2].[Incident_Location], [dbo].[ODR_v2].[Possible_Motivation], [dbo].[ODR_v2].[Persons_offending], [dbo].[ODR_v2].[Num_of_Offenders], [dbo].[ODR_v2].[Teacher_Email], [dbo].[ODR_v2].[Admin_Email], [dbo].[ODR_v2].[Consequence_Date], [dbo].[ODR_v2].[Consequence_Date_Thru], [dbo].[ODR_v2].[Num_Days], [dbo].[ODR_v2].[Parent_Phone], [dbo].[ODR_v2].[Parent_Contact_Date_Admin], [dbo].[ODR_v2].[Parent_Contact_Time], [dbo].[ODR_v2].[Parent_Contact_Type], [dbo].[ODR_v2].[Admin_Comments], [dbo].[StuSchool].[ENRLAST], [dbo].[StuSchool].[ENRFRST], [dbo].[StuSchool].[GR], [dbo].[StuSchool].[ETH], [dbo].[StuSchool].[PRIMEXCP], [dbo].[StuSchool].[DOB], [dbo].[StuSchool].[PMSCHL], [dbo].[ODR_v2].[Hours], [dbo].[ODR_v2].[GroupID4], [dbo].[StuSchool].[SCHL], [dbo].[ODR_v2].[TERMS_Empl] FROM dbo.ODR_v2 INNER JOIN dbo.StuSchool ON dbo.ODR_v2.StudentID = dbo.StuSchool.ENRKSTDT where dbo.ODR_v2.ID=2315
SELECT top 1 [dbo].[ODR_v2].[StudentID], [dbo].[ODR_v2].[Incident_Date], [dbo].[ODR_v2].[ID], [dbo].[ODR_v2].[Incident_Time], [dbo].[ODR_v2].[Describe_Behavior], [dbo].[ODR_v2].[Parent_Contact], [dbo].[ODR_v2].[Parent_Contact_Date], [dbo].[ODR_v2].[Parent_Contact_Detail], [dbo].[ODR_v2].[Action_Recommended], [dbo].[ODR_v2].[Incident_Location], [dbo].[ODR_v2].[Possible_Motivation], [dbo].[ODR_v2].[Persons_offending], [dbo].[ODR_v2].[Num_of_Offenders], [dbo].[ODR_v2].[Teacher_Email], [dbo].[ODR_v2].[Admin_Email], [dbo].[ODR_v2].[Consequence_Date], [dbo].[ODR_v2].[Consequence_Date_Thru], [dbo].[ODR_v2].[Num_Days], [dbo].[ODR_v2].[Parent_Phone], [dbo].[ODR_v2].[Parent_Contact_Date_Admin], [dbo].[ODR_v2].[Parent_Contact_Time], [dbo].[ODR_v2].[Parent_Contact_Type], [dbo].[ODR_v2].[Admin_Comments], [dbo].[StuSchool].[ENRLAST], [dbo].[StuSchool].[ENRFRST], [dbo].[StuSchool].[GR], [dbo].[StuSchool].[ETH], [dbo].[StuSchool].[PRIMEXCP], [dbo].[StuSchool].[DOB], [dbo].[StuSchool].[PMSCHL], [dbo].[ODR_v2].[Hours], [dbo].[ODR_v2].[GroupID4], [dbo].[StuSchool].[SCHL], [dbo].[ODR_v2].[TERMS_Empl] FROM [dbo].[ODR_v2] INNER JOIN [dbo].[StuSchool] ON [dbo].[ODR_v2].[StudentID] = dbo.StuSchool.ENRKSTDT WHERE ((dbo.ODR_v2.ID<2315 or dbo.ODR_v2.ID IS NULL)) and ((1=1) and (upper(dbo.StuSchool.ENRLAST) like upper(N'%sponge%'))) ORDER BY 3 DESC
SELECT top 1 [dbo].[ODR_v2].[StudentID], [dbo].[ODR_v2].[Incident_Date], [dbo].[ODR_v2].[ID], [dbo].[ODR_v2].[Incident_Time], [dbo].[ODR_v2].[Describe_Behavior], [dbo].[ODR_v2].[Parent_Contact], [dbo].[ODR_v2].[Parent_Contact_Date], [dbo].[ODR_v2].[Parent_Contact_Detail], [dbo].[ODR_v2].[Action_Recommended], [dbo].[ODR_v2].[Incident_Location], [dbo].[ODR_v2].[Possible_Motivation], [dbo].[ODR_v2].[Persons_offending], [dbo].[ODR_v2].[Num_of_Offenders], [dbo].[ODR_v2].[Teacher_Email], [dbo].[ODR_v2].[Admin_Email], [dbo].[ODR_v2].[Consequence_Date], [dbo].[ODR_v2].[Consequence_Date_Thru], [dbo].[ODR_v2].[Num_Days], [dbo].[ODR_v2].[Parent_Phone], [dbo].[ODR_v2].[Parent_Contact_Date_Admin], [dbo].[ODR_v2].[Parent_Contact_Time], [dbo].[ODR_v2].[Parent_Contact_Type], [dbo].[ODR_v2].[Admin_Comments], [dbo].[StuSchool].[ENRLAST], [dbo].[StuSchool].[ENRFRST], [dbo].[StuSchool].[GR], [dbo].[StuSchool].[ETH], [dbo].[StuSchool].[PRIMEXCP], [dbo].[StuSchool].[DOB], [dbo].[StuSchool].[PMSCHL], [dbo].[ODR_v2].[Hours], [dbo].[ODR_v2].[GroupID4], [dbo].[StuSchool].[SCHL], [dbo].[ODR_v2].[TERMS_Empl] FROM [dbo].[ODR_v2] INNER JOIN [dbo].[StuSchool] ON [dbo].[ODR_v2].[StudentID] = dbo.StuSchool.ENRKSTDT WHERE ((dbo.ODR_v2.ID>2315)) and ((1=1) and (upper(dbo.StuSchool.ENRLAST) like upper(N'%sponge%'))) ORDER BY 3 ASC
Microsoft SQL Server Native Client 10.0 error '80040e31'
Query timeout expired
/odr/include/aspfunctions.asp, line 1243
It looks like your query takes long time to execute causing SQL Server timeout. Here is the article that explains how to print all executed queries on the web page:
http://xlinesoft.com/asprunnerpro/docs/debugging_tips.htm