Somehow I managed to disassociate the .mdf file extension with a SQL Server Database. I have not been able to find anywhere to restore the association. I have checked on other computers and they all indicate that the program is "unavailable"
This becomes a problem when I am trying to re-attach a database for upgrade purposes from 2000 to 2005 as it will not recognize it as a valid file format.
Do I have to go back into 2000 and script everything out in order to bring it into the higher versions of SQL? I was hoping for a faster cleaner upgrade and not losing any of my table settings -- mostly my default field settings for the 75+ tables that are there.
My overall goal is to move everything over to SQL 2008 and my ADP's to 2007. Anyone have suggestions?