Geek Answers Handbook

Error opening SQL file from TFS 2012

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

TF10187: Failed to open document

FilePath \ filename

User canceled from save dialog

Error message

This only happens for SQL files. The file exists in the TFSTemp folder, and I can double-click it and open it. What do I need to change to fix this error message?

+7
source share
3 answers

It looks like you need to uninstall Redgate and then install the data tools again. This is probably due to the add-in trying to capture .SQL files and do something with them that VS did not expect.

0
source

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

+4
source

For us, this seems to be related to updating the .NET Framework 4.6 and is not limited to SQL files. Users have problems opening files from Source Control Explorer and Solution Explorer.

Opening from Source Control Explorer Discovery from solution

  • Delete contents from the following folders:

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

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

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

  • The first step fixed it in my case, but you can try it if it is not: go to the Visual Studio IDE folder on the command line or in Windows Explorer and run the following command "devenv / resetuserdata". That is: C: \ Program Files (x86) \ Microsoft Visual Studio 11.0 \ Common7 \ IDE. To minimize the potential loss of users ’personal environment, you should consider backing up using the export settings wizard and the import settings wizard to restore the settings if and when necessary.

Note. Side effects of running the / resetuserdata option are that any settings must be reconfigured (that is: TFS server and proxy settings), as well as many, if not all, Visual Studio extensions need to be reinstalled.

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

+2
source

More articles:


All Articles