error while try to attach database to sql server2005
-
i try to attach a database to sqlserver 2005 in my computer when click attach i see a exception with this message : TITLE: Microsoft SQL Server Management Studio ------------------------------ Attach database failed for Server 'SHOKRIAN'. (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 9, object ID 1, index ID 1. Run DBCC CHECKTABLE on sysindexes. Could not open new database 'ProposalSystem'. 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 ------------------------------ help to silv this problem plz
-
i try to attach a database to sqlserver 2005 in my computer when click attach i see a exception with this message : TITLE: Microsoft SQL Server Management Studio ------------------------------ Attach database failed for Server 'SHOKRIAN'. (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 9, object ID 1, index ID 1. Run DBCC CHECKTABLE on sysindexes. Could not open new database 'ProposalSystem'. 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 ------------------------------ help to silv this problem plz