CODEWITHSUNDEEP
visual-studio-2012tfs
Greg
Greg

Reputation: 3522

Error opening SQL File from TFS 2012

When I try to view a .sql file from Source Control Explorer in Visual Studio 2012 (TFS 2012) I get the following error message:

TF10187: Could not open document

FilePath\FileName

User canceled out of save dialog

Error Message

It's only happening for SQL files. The file does exist in the TFSTemp folder and I can double click and open it from there. What do I need to change to fix this error message?

Upvotes: 8

Views: 7793

Answers (3)

Josh Johanning
Josh Johanning

Reputation: 1245

For us, this seems to be linked to a .NET Framework 4.6 upgrade and is not limited to SQL files. Users have issues opening files from Source Control Explorer and Solution Explorer.

Opening from Source Control Explorer Opening from Solution

  1. Delete the contents from the following folders:

    C:\Users\<>\AppData\Local\Microsoft\Team Foundation

    C:\Users\<>\AppData\Local\Microsoft\VisualStudio

    C:\Users\<>\AppData\Local\Microsoft\VSCommon

  2. The first step fixed it in my case, but you can try this if it doesn't: Navigate to the Visual Studio IDE folder in command prompt or windows explorer and Run the following command "devenv /resetuserdata". Ie: C:\Program Files (x86)\Microsoft Visual Studio 11.0\Common7\IDE. To minimize the potential loss of the user’s personal environment, you should consider creating a backup using the Export Settings wizard, and the Import Settings wizard to restore the settings if and when needed.

Note: The side effects of running the /resetuserdata option is that any customizations will have to be reconfigured (ie: TFS server and proxy settings) as well as many, if not all, Visual Studio extensions have to be re-installed.

Source: http://blogs.msdn.com/b/willy-peter_schaub/archive/2010/09/15/if-you-have-problems-with-tfs-or-visual-studio-flush-the-user-cache-or-not.aspx

Upvotes: 2

Manish Dalal
Manish Dalal

Reputation: 111

Install SQL Server Data Tools - September 2013 update things will be fine. http://msdn.microsoft.com/en-us/jj650015

Upvotes: 4

Martin Woodward
Martin Woodward

Reputation: 11770

Looks like you need to uninstall Redgate and then re-install the data tools. This is probably because an add-in was trying to grab the .SQL files and do something with them that VS wasn't expecting.

Upvotes: 0

Related Questions