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

sql-server visual-studio visual-studio-2012 sql-server-2012
ProfK picture ProfK · Dec 2, 2012 · Viewed 17.1k times · Source

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.

Answer

ProfK picture ProfK · Dec 3, 2012

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

Related questions

Do I need a database reference for a linked server in a SQL Server database project?

In my database project, I have added a reference to a linked server. When I use this linked server in a view and try to build my database project, SSDT reports errors because it cannot understand references to any of …

Read More
Why am I getting "Cannot Connect to Server - A network-related or instance-specific error"?

I get the following error when trying to connect to SQL Server: Cannot connect to 108.163.224.173. A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the …

Read More
How to get the connection String from a database

I have created a database with SQL Server Management Studio, I would like to now use it in my C# application. I need the connection string? Where can I find the connection string, and where is my database stored? Do …

Read More