I use xp_sendmail with a query. Here is the syntax of the stored proc, which invokes it…

Exec master..xp_sendmail

@recipients='my email’,

@subject='Newborn Row Count',

@message='Monthly update',

@attachments='RowCount.csv',

@query='exec newborn..spRowCount',

@attach_results=true,

@width=500,

@separator = ''

This proc is run by...

It happened again last night...

DESCRIPTION:Error: 605, Severity: 21, State: 1

Attempt to fetch logical page (1:397912) in database 'Newborn' belongs to object 'SPECIMEN', not to object 'LAB_RESULT'.

Reindex job was running when...

Yes, that is the case, that is why it is in that mode.

All the KBs I found suggest that once the repair options are done, the problem will be gone,...

The server is Win2K sp 4. Running SQL 2000 (8.00.665)

One weird thing is that the database runs in 65 compatibility mode.

Thanks, Sean