sql sever2005 - 未名空间MITBBS历史存档

国际科技财经博客移民网络热点娱乐民生时事公众号

Redian新闻

>未名空间

>Database - 数据库

sql sever2005

sql sever2005# Database - 数据库

c*e2008-02-02 08:02

1 楼

帮帮忙，谁给给看看。
以前有２０００ EVALUATION VERSION，现在装了个２００５的 EVALUATION VERSION
想要试下那个BI DEV STUDIO。就去装EXAMPLE DATA
怎那个个AdventureWorksDW_Data.mdf 横竖
ATTACH不上呢，ERROR MSG：Could not find row in sysindexes for database ID 7,
object ID 1, index ID 1. Run DBCC CHECKTABLE on sysindexes.
Could not open new database 'AdventureWorksDW'. CREATE DATABASE is aborted.
(.Net SqlClient Data Provider)

w*e2008-02-02 08:02

2 楼

首先看看是不是attach到2000上了....一定要make sure

7,
.

【在 c********e 的大作中提到】

: 帮帮忙，谁给给看看。
: 以前有２０００ EVALUATION VERSION，现在装了个２００５的 EVALUATION VERSION
: 想要试下那个BI DEV STUDIO。就去装EXAMPLE DATA
: 怎那个个AdventureWorksDW_Data.mdf 横竖
: ATTACH不上呢，ERROR MSG：Could not find row in sysindexes for database ID 7,
: object ID 1, index ID 1. Run DBCC CHECKTABLE on sysindexes.
: Could not open new database 'AdventureWorksDW'. CREATE DATABASE is aborted.
: (.Net SqlClient Data Provider)

c*e2008-02-02 08:02

3 楼

Thanks, I found it. With SQL 2005 ENV, I wasn't able to create an Instance.
So what I was trying to attach to is still the old instance on 2000, that is
why. So, I had to install an express version to get a new 2005's instance.
Thank you so much!

【在 w*******e 的大作中提到】

: 首先看看是不是attach到2000上了....一定要make sure
:
: 7,
: .