Results 1 to 4 of 4

Thread: how do i stop a query that is taking a log time?

  1. Feb 5th, 2003, 10:41 AM #1
    tmashley
    tmashley is offline

    Thread Starter
    Addicted Member
    Join Date
    Oct 2002
    Posts
    128

    how do i stop a query that is taking a log time?

    hello,

    how can i stop a query running,
    the button will be on a web application
    code is vb.net
    the query collects data from a inSQL database on the web server

    anybody got any ideas?

    Tom.
    Reply With Quote Reply With Quote
  2. Feb 6th, 2003, 05:27 AM #2
    aidan
    aidan is offline
    Lively Member
    Join Date
    Sep 2002
    Posts
    103
    That's a really interesting question. I hope you get an answer. If it is possible, I suspect it would be by setting a time limit before you execute the query.
    Reply With Quote Reply With Quote
  3. Feb 6th, 2003, 09:45 AM #3
    RichardAtherton
    RichardAtherton is offline
    Hyperactive Member
    Join Date
    Mar 2002
    Location
    Dublin (Ireland)
    Posts
    304
    Well i should be change the timeout value. Not anywhere near VB .Net at the moment but I would guess it's a property of the connection that can be changed.
    Reply With Quote Reply With Quote
  4. Feb 6th, 2003, 01:19 PM #4
    Mr.No
    Mr.No is offline
    Fanatic Member Mr.No's Avatar
    Join Date
    Sep 2002
    Location
    Mauritius
    Posts
    651
    I'm not in front of a VS.NET machine but I guess the SQLCommand object should have a timeout property
    Using VB.NET 2003/.NET 1.1/C# 2.0
    http://del.icio.us/rajoo
    Blow your mind, smoke gunpowder
    Ashes to ashes, dust to dust
    If God won't have you, the devil will. - Author unknown
    Don't follow me, I'm lost too ...
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width