Problem with Temp Tables and Logging

Mark, Aborting of long transactions occurs when the logs become full to the limit specified in you onconfig file ( or whatever you are using ) There are two solutions to this problem: Increase the size and/or amount of logs available Increase the High or Low water marks in your config file but be careful not to put them too high ( perhaps no more than 75% ) as this will cause the engine to crash if it runs out of log space before it rolls back. The only recovery if this happens is a level 0 restore Hope this help -- Terry Boyland Why should I give someone else's opinion This is MY OWN !!