I can suddenly no longer open .sql files in VS 2012 by simply double clicking in the Solution Explorer. I get the error message:
Unable to open Transact-SQL file in custom editor
I strongly suspect this is after installing SP1 for SQL Server 2012 Express yesterday, as part of Windows Updates. The error dialogue gives me a link to Get the latest version of SQL Server Data Tools, but that link only yields a Page not found on MSDN.
8. Which of the following component is not installed by SQL Server setup 2012 required by the product? Explanation: SQL Server Setup will block installations on read-only or compressed drives. 9.
Issue: Sync Framework is not included in the SQL Server 2012 installation package.
When installing SQL Server 2014 or SQL Server 2012, SSMS requires Visual Studio 2010 Shell (Isolated) and SSDT requires Visual Studio 2010 Shell (Integrated). According to Microsoft lifecycle policy of Visual Studio 2010, the support ended on July 14, 2020.
Installing the SQL Server Data Tools - November 2012 update fixed the SQL editor. All is good in the world again.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With