Friday, February 17, 2012

error attaching adventureworks database and SSIS training database

Hi there,

I got this error when i tried to attach the adventureworks database and SSIS training database.

an exception occurred while executing a transact-sql statement or batch
(microsoft.sqlserver.connectioninfo)

could not find row in sysindexes for database ID 17, object ID 1, index ID 1. Run DBCC
checktable on sysindexes.

I join join a network domain for my computer. Previously it doesnt have this problem.

Hello,

It appears that you are trying to attach a SQL Server 2005 database to an instance of SQL Server 2000 or earlier. Please try to attach the AV database to a SQL Server 2005 instance.

Derrick VanArnam - MSFT

No comments:

Post a Comment