Home / server / Questions / 489703
In Process
Alex KeySmith
Asked: 2013-03-21 07:40:07 +0800 CST

What happens if a stored procedure is run in SSMS and it crashes?

  • 772

What happens if a stored procedure is run in sql server management studio (SSMS 2012 to 2005 server) and it crashes?

I'm guessing the stored procedure continues to run?

On the other hand I have read somewhere that if a connection is lost and a transaction is used, then the transaction automatically rolls back?

sql-server-2005

1 Answers

  1. If connection is lost, your session will be closed and all transactions will be rolled back. If you want to run your procedure without interruption, you could execute it as a job.

    • 3