SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
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  

heero
Starting Member

Singapore
33 Posts

Posted - 05/04/2004 :  23:01:27  Show Profile
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!

Australia
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.



Damian
Go to Top of Page

nr
SQLTeam MVY

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-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000