CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2005
    Posts
    158

    Started SP from batch

    At work we have a Visual Foxpro 6 program that runs on a scheduled task. All it does is call a stored procedure to run on SQL Server 2000. It looks like the program was 'hanging' so we killed it. What I'm wondering is does the SP continue to run if the 'host' program was stopped? I'm thinking yes, but I can't find a way to see what's running on the server.

    I guess I have two questions then:
    Is the SP still running?
    How can I check?

    Thanks a ton.

  2. #2
    VictorN's Avatar
    VictorN is offline Super Moderator Power Poster
    Join Date
    Jan 2003
    Location
    Hanover Germany
    Posts
    20,396

    Re: Started SP from batch

    After the connection between your app and SQL Server had been closed/cancelled/broken - all the actions related to this connection broke too.
    Victor Nijegorodov

  3. #3
    Join Date
    Oct 2005
    Posts
    158

    Re: Started SP from batch

    Interesting. I was split thinking one way or the other but couldn't think of a good way to tests, and I couldn't come up with a good search.

    Thanks for the info.

  4. #4
    VictorN's Avatar
    VictorN is offline Super Moderator Power Poster
    Join Date
    Jan 2003
    Location
    Hanover Germany
    Posts
    20,396

    Re: Started SP from batch

    As for batch - try sqlcmd Utility
    Victor Nijegorodov

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

Featured