Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Save Password
Forgot your Password?

 All Forums
 Old Forums
 CLOSED - General SQL Server
 sql query analyzer
 Forum Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

Starting Member

33 Posts

Posted - 05/04/2004 :  23:01:27  Show Profile

when i was trying my sql stmt at the sql query analyzer, it show the outcome that i want but when i try to put the code into the program it din work out..

below is the error:
Error Type:
Active Server Pages, ASP 0113 (0x80004005)
The maximum amount of time for a script to execute was exceeded. You can change this limit by specifying a new value for the property Server.ScriptTimeout or by changing the value in the IIS administration tools.

y isit so?? isit becos my code cannot support the sql stmt?

pls advice

thanks and regards

Funky Drop Bear Fearing SQL Dude!

4970 Posts

Posted - 05/04/2004 :  23:14:12  Show Profile  Visit Merkin's Homepage
The error tells you exactly what is wrong, and exactly how to fix it.

Go to Top of Page


United Kingdom
12543 Posts

Posted - 05/05/2004 :  01:18:28  Show Profile  Visit nr's Homepage
How long did the query take in query analyser.
You can use the profiler to see if the asp page is actually contacting the server and trying to execute the query.

Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.
Go to Top of Page
  Previous Topic Topic Next Topic  
 Forum Locked
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2019 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.04 seconds. Powered By: Snitz Forums 2000