Can you check your report server to see which object has ID 258647932? Maybe it was corrupted in your production server.

Edited by - allen_cui on 08/27/2003 08:57:02 AM

Send dead lock information to SQL Server errorlog.

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Customers]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)

drop table [dbo].[Customers]

GO

sp_depends

http://support.microsoft.com/default.aspx?scid=kb;en-us;812915

Can you post the completed error message?

http://support.microsoft.com/default.aspx?scid=kb;en-us;307775

It is the hot fix that resloves SQL Server performance counters missing from performance monitor. MS03-031 build number is 8.00.818.

I have no chance to use 64 bits SQL Server but...

quote:

---

I'm worried about the system files, the actual SQL Server executables, DLLs, log files, etc. found under \Program Files\Microsoft SQL Server....

sp_columns 'yourtablename'

I would suggest to trace the network connection/activities between your SQL Server and AS/400 machines to see any network breakdown during the data movement.

Run dbcc traceon(1204, 3605, -1) to log dead lock information to your SQL Server errorlog.

You really don't have to move everything unless you have other reasons. Creating second database file on new driver for your user databases or move them to new driver with...

Profiler from SQL Server itself.

Did they detach the database before copy MDF/LDF? You can also Ask them backup database and send it to you.