Hello,

I´ve reinstalled from scratch SQL 7 and was executing a loop that consists in calculating balances for each day, from august 1st to november 30th.

when executing august 20th, appeared the following message on the result:

<result of stored procedure >

(3861 row(s) affected)

Location: alloc.cpp:7859
Expression: IAM_bp != NULL
SPID: 7
Process ID: 122
Server: Msg 3624, Level 20, State 1, Procedure p_pmp_carga_unificado_csg, Line 671


DB-Library Process Dead - Connection Broken


Tried to fix executing :

dbcc checkdb
go
dbcc newalloc
go
dbcc checkcatalog
go
dbcc updateusage(0)
go

but it didn´t fixed DB. It has shown the messages below:

<result of dbcc newalloc(database,repair_allow_data_loss) >

Server: Msg 8906, Level 16, State 1
Page (1:87) in database ID 9 is allocated in the SGAM (1:3) and PFS (1:1), but was not allocated in any IAM. PFS flags &#39;MIXED_EXT ALLOCATED 100_PCT_FULL&#39;.
Server: Msg 8906, Level 16, State 1
Page (1:98) in database ID 9 is allocated in the SGAM (1:3) and PFS (1:1), but was not allocated in any IAM. PFS flags &#39;MIXED_EXT ALLOCATED 100_PCT_FULL&#39;.
Server: Msg 8906, Level 16, State 1
Page (1:99) in database ID 9 is allocated in the SGAM (1:3) and PFS (1:1), but was not allocated in any IAM. PFS flags &#39;MIXED_EXT ALLOCATED 100_PCT_FULL&#39;.
Server: Msg 8906, Level 16, State 1
Page (1:101) in database ID 9 is allocated in the SGAM (1:3) and PFS (1:1), but was not allocated in any IAM. PFS flags &#39;MIXED_EXT ALLOCATED 100_PCT_FULL&#39;.
Server: Msg 8906, Level 16, State 1
Page (1:110) in database ID 9 is allocated in the SGAM (1:3) and PFS (1:1), but was not allocated in any IAM. PFS flags &#39;MIXED_EXT ALLOCATED 100_PCT_FULL&#39;.

Does anyone know how to fix it?

TKS

Masa