-
June 10th, 2010, 08:44 AM
#1
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.
-
June 10th, 2010, 11:07 AM
#2
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
-
June 10th, 2010, 11:09 AM
#3
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.
-
June 10th, 2010, 11:18 AM
#4
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|