i've attempt to atach the adventureWorks database to follow the webcourse 2924 but I got the following error:
TITLE: Microsoft SQL Server Management Studio
Attach database failed for Server 'localhost'. (Microsoft.SqlServer.Smo)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.2047.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 28, 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)
But, how can I run DBCC CHECKTABLE on non attached database?
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=602&LinkId=20476
BUTTONS:
OK
Mary,
Please follow this article to attach AW.
http://msdn2.microsoft.com/en-us/library/ms310325.aspx
No comments:
Post a Comment