CODEWITHSUNDEEP
sql-servervisual-studiovisual-studio-2012sql-server-2012
ProfK
ProfK

Reputation: 51064

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.

Upvotes: 29

Views: 17323

Answers (3)

Hogan
Hogan

Reputation: 319

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

Upvotes: 1

ProfK
ProfK

Reputation: 51064

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

Upvotes: 43

Lars
Lars

Reputation: 119

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.

Upvotes: 7

Related Questions