Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How can I fix the T-SQL editor in VS 2012 after installing SQL Server 2012 SP1?

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.

like image 506
ProfK Avatar asked Dec 02 '12 07:12

ProfK


People also ask

Which of the following component is not installed by SQL Server Setup 2012 required by the product?

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.

Which component is not in SQL Server 2012?

Issue: Sync Framework is not included in the SQL Server 2012 installation package.

Is Visual Studio required for SSMS?

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.


1 Answers

Installing the SQL Server Data Tools - November 2012 update fixed the SQL editor. All is good in the world again.

like image 193
ProfK Avatar answered Oct 11 '22 21:10

ProfK