My verson of SQL Server stopped working at some point, and I've been spending some quality time attempting a repair. When I do, everything comes up roses except for one item: SQL Compact Edition Runtime. The one failure seems to be stopping SQL Server from running at all.
I am looking to buy a new laptop with Windows 7 on it, and my current computer has Windows XP. I'm afraid that if I can't get SQL Server to run on my XP, I won't be able to gain access to the data because the data files are all coupled and require decoupling before copying to another comuter and working properly. I've spent more hours than I care to mention trying to resolve the problem and get SQL Server wroking on my XP. My latest volley was downloading SQL Compact Edition Runtime from Microsoft: (http://www.microsoft.com/en-us/download/details.aspx?id=17876
). The download worked, but the problem didn't go away.
Anyone have any insight into this?