<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
SQL Server 7,2000
»
Data Corruption
»
Attaching AdventureWorks Database
Attaching AdventureWorks Database
Rate Topic
Display Mode
Topic Options
Author
Message
nisha.lakhwara
nisha.lakhwara
Posted Tuesday, June 24, 2008 6:11 AM
Grasshopper
Group: General Forum Members
Last Login: Wednesday, October 07, 2009 12:52 AM
Points: 16,
Visits: 31
Hi,
When I tried attaching the AdventureWorks Database to the SQL 2005 I get the following error.
Msg 1813, Level 16, State 2, Line 1
Could not open new database 'AdventureWorks'. CREATE DATABASE is aborted.
Msg 602, Level 21, State 50, Line 1
Could not find row in sysindexes for database ID 8, object ID 1, index ID 1. Run DBCC CHECKTABLE on sysindexes.
Could you please let me know how can I attach the AdventureWorks Database.
Post #522478
GilaMonster
GilaMonster
Posted Tuesday, June 24, 2008 6:15 AM
SSC-Dedicated
Group: General Forum Members
Last Login: Today @ 4:11 PM
Points: 37,741,
Visits: 30,020
Looks like you're trying to attach a SQL 2005 database to a SQL 2000 instance.
Adventure works is SQL 2005, hence can only be attached to SQL 2005 or higher.
Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild
: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter
We stand on the bridge and no one may pass
Post #522481
nisha.lakhwara
nisha.lakhwara
Posted Tuesday, June 24, 2008 9:43 AM
Grasshopper
Group: General Forum Members
Last Login: Wednesday, October 07, 2009 12:52 AM
Points: 16,
Visits: 31
No, I am attaching it in SQL 2005 Management Studio only.. the is SQL Server Authentication.But still not able to attach it.
Post #522654
GilaMonster
GilaMonster
Posted Tuesday, June 24, 2008 11:51 PM
SSC-Dedicated
Group: General Forum Members
Last Login: Today @ 4:11 PM
Points: 37,741,
Visits: 30,020
The client tool is management studio, I'm asking about the database engine you're trying to attach to. Thing is, that's a SQL 2000-specific error
Open a query to the SQL instance you're trying to attach the database to and run SELECT @@Version
Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild
: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter
We stand on the bridge and no one may pass
Post #523030
myskimpublic
myskimpublic
Posted Wednesday, September 10, 2008 12:46 PM
Forum Newbie
Group: General Forum Members
Last Login: Wednesday, September 10, 2008 12:40 PM
Points: 1,
Visits: 0
Gila Monster. Thank you very much. I've been trying to figure out what I was doing wrong for the longest time. I didn't realize the error I was getting was because my Sql management studio was connecting to the wrong sql server 2000k instance. You're response to the original posting helped me a lot. :)
Post #567220
rachana.1125
rachana.1125
Posted Monday, May 09, 2011 6:56 AM
Forum Newbie
Group: General Forum Members
Last Login: Monday, May 09, 2011 10:57 PM
Points: 1,
Visits: 2
Hi,
When I tried attaching the AdventureWorks Database to the SQL 2005 I get the following error.
Msg 1813, Level 16, State 2, Line 1
Could not open new database 'AdventureWorks'. CREATE DATABASE is aborted.
Msg 602, Level 21, State 50, Line 1
Could not find row in sysindexes for database ID 8, object ID 1, index ID 1. Run DBCC CHECKTABLE on sysindexes.
Post #1105392
GilaMonster
GilaMonster
Posted Monday, May 09, 2011 7:01 AM
SSC-Dedicated
Group: General Forum Members
Last Login: Today @ 4:11 PM
Points: 37,741,
Visits: 30,020
That's a SQL 2000 instance, not SQL 2005 (run Select @@version to prove it).
AdventureWorks is a 2005 or 2008 database and can only be attached to those versions. Downgrade of a database is never possible.
Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild
: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter
We stand on the bridge and no one may pass
Post #1105397
« Prev Topic
|
Next Topic »
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
