Visual Studio gets stuck on opening a sql project

Question

We are trying to setup a sql project, in a new machine with Windows 7, VS 2010 with SP1 & SSDT 2010 (installed SSDT 2010 from iso image). But getting the below message when I open the sqlproj.

'Verifying your model is synchronized with your source files. Your database will be ready in 12734 operations are completed.' And the number keeps on increasing. And it keeps on running in the background.

Tried re-installing SSDT, VS 2010 but no help.

Created a new database project for Northwind db, and had the same issue. Ran procmon and saw it's just going over and over the same files.

It works fine in another system with similar configuration.

EDIT

The issue seems to be related to TFS, if we unbind from TFS it works fine. But not sure about the exact cause.

Any suggestion would be really helpful.

score 19 · Accepted Answer · answered Feb 26 '15 at 20:42

19

My suggestion is if you are using source control such as Git and you have just switched branches and you are hitting this issue is to use git clean which will remove untracked files (which VS and SSDT are choking up on)

git clean -fdx

Not sure what to use if you are on TFS or SVN or HG.. but same idea applies

answered Feb 26 '15 at 20:42

superlogical

14,332
9
66
76

This seemed to work for me, especially as sometimes there a lot of untracked files created by SSDT – Matt McCabe Nov 18 '15 at 15:30
Wish I could up-vote this several more times! Really pleased to have got VS 2015 finally working. Many thanks. – user489998 Feb 01 '16 at 11:18
This is a fix in sorts but...I just wondered if anyone knew which file in particular is causing the system to lock. – atreeon Jul 11 '16 at 14:02
3

Don't forget to commit any uncommitted work before doing this (like I just did) :( – user489998 Jul 18 '16 at 08:35

atreeon · Answer 2 · 2016-07-14T12:31:47.700

6

I deleted the .suo file in the .vs folder in the root of solution directory. This fixed it for me. I think this is the best and least damaging answer as it preserves your modified files and some of your other settings (of course some settings such as your start up project will be lost)

edited Jul 14 '16 at 12:31

answered Jul 13 '16 at 16:17

atreeon

21,799
13
85
104

This worked for me in VS 2015. It was a project that was converted from 2013. – David Hammond Jan 10 '17 at 23:32

score 2 · Answer 3 · answered Jul 17 '14 at 11:24

2

MCafee antivirus was causing the issue. The issue got resolved after disabling the antivirus.

answered Jul 17 '14 at 11:24

Baga

1,354
13
24

3

Its _an_ answer, and a worthy one. Virus scanners often detect programming tools as being a problem or the realtime scan engines insist on scanning each and every file, causing this kind of slowdown. – StingyJack Mar 16 '18 at 19:58

Visual Studio gets stuck on opening a sql project

3 Answers3