BUG: Error 705 If a LOAD TRAN Statement Is Within a T-SQL Loop

• Microsoft SQL Server, version 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.

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.