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

17,220

Solution 1

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

Solution 2

Yes, yet another bug in SQL Server 2012 roll eyes

Right click on the SQL file and choose "Open With...". Choose "Source Code (Text) Editor" and choose "Set as Default".

Now it works again.

Solution 3

Almost a year later, but I found the answer from joerage to be more helpful.

Default to the T-SQL Pane view within Visual Studio 2012 Database Project

Share:
17,220
ProfK
Author by

ProfK

I am a software developer in Johannesburg, South Africa. I specialise in C# and ASP.NET, with SQL Server. I have, in some way or another, been involved in software development for about eighteen years, but always learning something new. At the moment that is WPF and MVVM.

Updated on June 07, 2022

Comments

  • ProfK
    ProfK about 2 years

    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.