Home > IT Answers > SQL Server > unable to attach sample database in SQL 2005
Ismav
5 pts.
 unable to attach sample database in SQL 2005
Microsoft SQL Server Management Studio, Microsoft.SqlServer.Smo, SQL Server 2005
Hi, I installed SQL server 2000 and SQL 2000 SP4. Than I installed SQL Server 2005. But when I am trying to attach the AdventureWorks Sample database, I am getting the following error: TITLE: Microsoft SQL Server Management Studio ------------------------------ An error occurred when attaching the database(s). Click the hyperlink in the Message column for details. ------------------------------ BUTTONS: OK ------------------------------ ------------------------------ TITLE: Microsoft SQL Server Management Studio ------------------------------ Attach database failed for Server 'VAMSI'. (Microsoft.SqlServer.Smo) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Attach+database+Server&LinkId=20476 ------------------------------ ADDITIONAL INFORMATION: An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo) ------------------------------ 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 'AdventureWorks'. CREATE DATABASE is aborted. (Microsoft SQL Server, Error: 602) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=602&LinkId=20476 ------------------------------ BUTTONS: OK ------------------------------ Can you please help me, how to resolve this issue.

Software/Hardware used:
ASKED: July 6, 2008  9:51 PM
UPDATED: July 7, 2008  1:13 PM
RELATED QUESTIONS
Answer Wiki:
It sounds to be like there is a problem with the AdventureWorks database that you are trying to attach. You might want to download the sample database again and try attaching the new copy.
Last Wiki Answer Submitted:  July 6, 2008  9:57 pm  by  Denny Cherry   64,505 pts.
All Answer Wiki Contributors:  Denny Cherry   64,505 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

Check out my SQL Server blog “SQL Server with Mr Denny” for more SQL Server information.

Denny Cherry
 64,505 pts.