Monday, February 13, 2012

Attaching Database 'AdventureWorks'

Hi,
I have installed SQL Server 2005 CTP/Trial Version.
When I try to attach the database 'AdventureWorks', I get the following error.
Could not find row sysindexes for database ID 11, Object ID 1, index ID 1.
Run DBCC
CHECKTABLE on sysindexes
Could not open new database 'AdventureWorks'. CREATE DATABASE is aborted.
I also tried suggestions in BooksOnline but it didn't help.
Please advise how to attach the database.
Thanks a lot
Steve
IT Developer
You have asked this question in four different places that I have seen and
have already gotten a response. Please do not multipost.
Thanks!
HTH
Kalen Delaney, SQL Server MVP
www.solidqualitylearning.com
"Steve" <Steve@.discussions.microsoft.com> wrote in message
news:290AD911-24FA-419B-8A26-636CC009B189@.microsoft.com...
> Hi,
> I have installed SQL Server 2005 CTP/Trial Version.
> When I try to attach the database 'AdventureWorks', I get the following
> error.
> Could not find row sysindexes for database ID 11, Object ID 1, index ID 1.
> Run DBCC
> CHECKTABLE on sysindexes
> Could not open new database 'AdventureWorks'. CREATE DATABASE is aborted.
> I also tried suggestions in BooksOnline but it didn't help.
> Please advise how to attach the database.
> Thanks a lot
> --
> Steve
> IT Developer
>

No comments:

Post a Comment