Results 1 to 3 of 3

Thread: ** Resolved **Abort SQL Server 2000 Stored Procedure FROM VB.Net

Threaded View

  1. #1

    Thread Starter
    Hyperactive Member vbud's Avatar
    Join Date
    Jan 2002
    Location
    Mru 20 17S, 57 33E Goal: Get out of the BOX Status: In The Shadows!!! Target Posts: 3,000,000,000
    Posts
    378

    Question ** Resolved **Abort SQL Server 2000 Stored Procedure FROM VB.Net

    hi all,

    I have a stored procedure running every night on an SQL Server database which is triggered through a VB.Net App. Sometimes the process is very long and might take a few hours. My problem is that I need to stop it if its taking too much time to be able to run other applications. I want to know if this is possible to do from within the VB.Net App, thas is to abort the processing of a stored procedure and cause it to stop.

    All help appreciated thanx.
    Last edited by vbud; Apr 5th, 2005 at 11:31 PM. Reason: Resolved
    >!v!<
    Free your mind, stop thinking
    http://inspirone.blogspot.com

    Please rate this post if it helped you

Posting Permissions

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



Click Here to Expand Forum to Full Width