I was able to edit Database projects in my installation of VS2010 ultimate. However per project requirements I had to uninstall SQL Server 2008 and install SQL Server 2008 R2. Now I have lost the ability to open sql files in VS2010 IDE. Whenever I double-click on a .sql file to open the script file, I get an "Object reference not set" error. Looks like the extension to edit SQL files in VS2010 has been removed.
How do I reinstall the T-SQL editor extension?
Have tried repairing both VS2010 and SQL Server 2010
Thanks