Problem after attaching DB to SQL 2005

• RSingh-135921

  Default port

  Points: 1438

  More actions

  June 14, 2006 at 3:38 pm

  #112665

   

  Hi,

  We just installed 64-bit SQL Server 2005 on our new Server having Windows Server 2003 x64 Enterprise Edition and having 2 AMD Opteron processors.

  I detached our database from SQL Server 2000 to SQL Server 2005. It did some upgradation from version 539 to 611.

  But the problem started now. One of our SPs which was executing perfectly fine in SQL 2000 has started giving this error in SQL 2k5:

  Server: Msg 682, Level 22, State 153, Procedure _agr_Activity_view_insert, Line 10

  Internal error. Buffer provided to read column value is too small. Run DBCC CHECKDB to check for any corruption.

  Can someone help us here?

  Regards,

  RSingh

• Jim Dillon-291542

  Hall of Fame

  Points: 3344

  More actions

  June 15, 2006 at 10:06 am

  #644017

  I think that one must update the 2000 stored procedures to be 2005 compliant. Look up update SQL Server 2000 stored procedures in BOL.

  You might also check out this article in BOL: ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/extran9/html/81702560-48a3-46d1-a469-e41304c7af8e.htm

  Good Luck,

  jim