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.

 All Forums
 Old Forums
 CLOSED - General SQL Server
 sql query analyzer

Author  Topic 

heero
Starting Member

33 Posts

Posted - 2004-05-04 : 23:01:27
hi

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

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
Go to Top of Page

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.
Go to Top of Page
   

- Advertisement -