Hey all, trying to attach to a database in SQL Server 2k5 Management Studio and I am getting the following Error:
--
TITLE: Microsoft SQL Server Management Studio
Attach database failed for Server '[MYDBSVRHERE]'. (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 '[MYDBNAMEHERE]'. 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
--
Does anybody have ANY idea about how to fix? Is this a permissions thing?
Thanks in advance!
thanks,
Dork|||Glad to hear you "fixed" the problem!|||
Hi,
my server have SQL Server 2000. I detach a database in this server and copy to my laptop.
I attact that database to SQL Server 2005 and do so many things on it.
some days after, i copy this file from my laptop to my server i try to attact it to SQL server 2000.
the same prolem appear.!!!
Does anyone know HOW TO fix? Thanks!
No comments:
Post a Comment