Look at third post up!

Thanks! Back in business-

petpet

Attach is grayed out on Enterprise Manager. I'm assuming it is because this particular database is in MS SQL 7.

Okay, just tried that and I get an error message that 'cannot associate files from different databases'

I just tried it, but it came back with the same error (...some of the files cannot be attached) since there is no LDF file.

Paul,

It doesn't work, and unfortunately I can't correctly detach it since it does not show up as existing at this point.

I unfortunately have gotten my MDF and LDF files out of sync. It gives me an error that the files are out of sync. I tried to delete...

When I try to attach to the new files, it gives me an error that the physical log file of the original file may not be correct. It then...

Maybe I'm misunderstanding the function of ATTACH. Does attach have SQL recognize a mdf and ldf file as a database and link the physical files to it. In...

Got half of it working! I was able to detach both databases and reattach one of them, however when I go to attach the other database, it says it...

Thanks. Looks like I don't have it. I was hoping the MS SQL 7 sp4 would load it when I downloaded it and installed it. Would anyone...

I was using the editor. I did now type it all on one line and it went by so fast, I couldn't tell if it worked. Is there...

Did try what you suggested in osql. I received a syntax error on the 2nd line. It seems to have a problem with @filename1.