SQL Server/Web Server Stopped in middle while executing procedue

• javidkhan

  Grasshopper

  Points: 11

  More actions

  January 8, 2010 at 2:42 am

  #214336

  Hi All,

  I have written procedure which take around 20 mins to execute. What will happen if Web server or SQL Server that I am using get stopped in middle by any reason? I mean whether it will keep all the operations performed up to that time as it is or will revert to initial stage?

• Nabha

  SSCrazy Eights

  Points: 8534

  More actions

  January 8, 2010 at 5:41 am

  #1100794

  Depends (on the code) on the transactional blocks of your stored procedure.

  http://msdn.microsoft.com/en-us/library/ms190612(SQL.90).aspx

  ---------------------------------------------------------------------------------