I've written a SQL 2000 stored procedure that goes into my database, checks to see whether or not indexes exist for my data, and if not, continues on and adds them.
However, I have about 650,000 records that need to be processed, holding up the script for a long time.
I've tried to use Server.Timeout to change the setting, but unfortunately that doesn't seem to be working.
My code is as follows:
<% option explicit
Response.Buffer = TRUE
Server.ScriptTimeout = 3600
b = c.Execute(index) 'index = "Execute sp_...."
The error I keep getting is:
Microsoft OLE DB Provider for SQL Server error '80040e31'
/web/list.asp, line 81
Line 81 is the Execute Line.
Any thoughts would be greatly appreciated.