Geek Answers Handbook

Is it possible to close SSMS but leave the stored procedure running?

Is it possible to close ms sql server management studio while the stored procedure is running without stopping the stored procedure?

+4
source share
3 answers

If you mean the SP you use in SSMS, then no. Obviously, closing your own SSMS will not affect the SPs that are launched from other users on the server.

+4
source

You really can't, however you can create an SQL agent job that will execute the stored proc, do you need the result set returned to you, or are you updating the data?

If this is an update, I think that you simply run it at the agent, and if not, then the next simplest way to return a long-term saved set of process results is to create an SSIS package that displays this result in csv, excel doc, which ever works. This package can also be run by SQL Agent.

+3
source

Yes, you can, but you cannot see the result of SP if something comes back. After completing the job, the server will run SP, not SSMS.

0
source

More articles:


All Articles