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.