Attaching Database 'AdventureWorks'???

3 Nov 2005 10:46 PM

Steve

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

3 Nov 2005 11:41 PM

Kalen Delaney

Steve

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

Show quote

"Steve" <St***@discussions.microsoft.com> wrote in message
news:406AFFB7-981F-4A9F-A293-FB787A72CA4A@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
>