table error problem

[Roy Goldhammer]

Hello there

I have procedure who create temp table #tmp, store a lot of data inside it
for moving it to another database.

on any 5 rerun of the procedure in job i'm getting an error like: Attempt to
fetch logical page (1:73868) in database 2 failed. It belongs to allocation
unit 72057594108903424 not to 72057594124763136

I have recreated all the used tables. and it still happen.

What can cause it?

[Erland Sommarskog]

Exactly which version of SQL Server do you have?

It sounds like it could be this bug: http://support.microsoft.com/kb/916086

It said to be fixed in the latest Service Pack for SQL 2005.

--
Erland Sommarskog, SQL Server MVP, esq...@sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Roy Goldhammer]

I've checked which version of Service packs is installed:

in one server it is SP2 (32 bit)
and another one it is RTM (64 bit)

how can i know if on the 64 bit it is fine?

"Erland Sommarskog" <esq...@sommarskog.se> wrote in message
news:Xns9DE371BE3...@127.0.0.1...

[Erland Sommarskog]

Roy Goldhammer (ro...@yahoo.com) writes:
> I've checked which version of Service packs is installed:
>
> in one server it is SP2 (32 bit)
> and another one it is RTM (64 bit)
>
> how can i know if on the 64 bit it is fine?

Running with SQL 2005 RTM is not fine. I suggest that you install SP3 on
both servers.