Trying to re-associate SQL 2005 MDF files to the correct executable file
Posted on 2009-07-11
I was attempting to attach to the Northwind database from SQL 2005 and it gave me some error.
Unfortunately, I pointed it/associated it to a filename called "sqlservr.exe" and now all my MDF File associations are all screwed up.
1. Can someone help me to reassociate it with the correct .exe or service file? For example, the LDF file shows an assocation with "SQL Server Database Transaction Log File (.ldf)"
2. How to successfully connect to the Northwind database from SQL 2005?
With many thanks,