I am trying to attach a single .mdf file Database using:
sp_attach_single_file_db @dbname = 'cctx'
, @physname = 'c:\MSSQL7\Data\cctx_data.mdf'
I do not have a .ldf file for the DB.
When I run the script I recieve:
Could not locate row in sysobjects for system catalog 'Sysobjects' in database 'cctx'. This system catalog should exist in all databases. Run DBCC CHECKTABLE
I can't run DBCC CHECKTABLE because the database is not attached yet.
This .mdf file is not attached to any server anywhere so I cannot work with it before moving it...
Also, I am running MSDE... no client tools.
Any help would be appriecitated.