Microsoft KB Archive/176494

{| = BUG: Error 705 If a LOAD TRAN Statement Is Within a T-SQL Loop =
 * width="100%"|

Last reviewed: February 16, 1998

Article ID: Q176494 The information in this article applies to:
 * Microsoft SQL Server, version 6.5

BUG #: 17379 (6.5)

SYMPTOMS
Successive transaction loads inside a loop may produce the following error:

Msg 705, Level 19, State 1 There is no room for process %d to store PROC_HDR 0x%lx in Pss. If you cycle the SQL Server after encountering the error 705, an error 624 is generated in syslogs. Either case makes the database suspect.

WORKAROUND
To work around this problem, do either of the following:

 Do not perform a LOAD TRANSACTION statement inside a Transact-SQL loop. -or- Use a scheduled task to do the LOAD TRANSACTION after each dump.

STATUS
Microsoft has confirmed this to be a problem in SQL Server version 6.5. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.
 * }