Visual Studio REALLY wants to create a database diagram

Question

I have a VS "weirdness" I am unable to solve or explain.

Every now and again (with no consistency of action I am doing at the time) Visual Studio prompts me if I want to add database diagramming elements (similar to how SQL Manager would ask you if you chose to add a DB diagram for the first time.). It then asks me about 10-15 times within a half minute.

Exact text of dialog: "This server does not have one or more of the database objects required to use database diagramming. Do you wish to create them? Yes/No/Help"

Has anyone else experienced this issue? Is there a way to ask it to be quiet?

Kindness,

Dan

Answer 1

The offending tool window was the Server Explorer. SInce closing it I have not had this behaviour re-occur. Still not sure exactly why.

Cheers,

Dan

Answer 2

Hi,

I've experienced the same strange issue several times. And yes, you are right I kept my server explorer active while working with linq. What triggered the popup was when I right clicked on the solution element within the solution explorer.

Thanks,

Robert

Answer 3

VS seems to be pretty keen on crawling sub folders, I'd suggest that with the Explorer open it's trying to read that folder repeatedly on failure. Letting Sql management create the elements (that don't do much harm anyway) should make it all go away.

Answer 4

I get this too from time to time. For me it seems to be related to source control checkins (which have nothing to do with the server explorer, go figure.)

When I get the error it seems to happen once for each connection added to the server explorer. But this time that just happened a few minutes ago I didn't even have the server explorer open. I wish I had thought to file a Connect bug for it but it probably would have just been closed as not reproducible.

Answer 5

Bug report here: http://connect.microsoft.com/VisualStudio/feedback/details/536426/database-diagramming-creation-dialog-keeps-popping-up-during-the-checkout-of-any-file

Apparently a bug in the pending changes window when using the filter by solution option. Very annoying! Turning off the filtering worked for me.