Long Running Transaction throws Out of Space Error 9002

• Jack Corbett

  SSC Guru

  Points: 184395

  More actions

  September 25, 2009 at 8:18 am

  #1058475

  Check out this article[/url]. Essentially you need to do your deletes in smaller batches and commit the transactions sooner.

  Jack Corbett
  Consultant - Straight Path Solutions
  Check out these links on how to get faster and more accurate answers:
  Forum Etiquette: How to post data/code on a forum to get the best help
  Need an Answer? Actually, No ... You Need a Question

• Ian Scarlett

  SSC-Insane

  Points: 23197

  More actions

  September 25, 2009 at 8:55 am

  #1058511

  This question has also been posted here http://www.sqlservercentral.com/Forums/Topic793659-338-1.aspx