Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
heero
Starting Member
33 Posts |
Posted - 2004-05-04 : 23:01:27
|
hiwhen 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 |
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2004-05-04 : 23:14:12
|
The error tells you exactly what is wrong, and exactly how to fix it.Damian |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2004-05-05 : 01:18:28
|
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. |
|
|
|
|
|