CODEWITHSUNDEEP
visual-studio-2008
Daniel Elliott
Daniel Elliott

Reputation: 22867

Visual Studio REALLY wants to create a database diagram

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"

Is there a way to ask it to be quiet?

Upvotes: 17

Views: 2410

Answers (5)

spottedone
spottedone

Reputation: 146

For me, closing DatabaseExplorer, disabling solution filter etc. simply did not work. Running VS Ultimate 2012 Update 4.

After some research, the following seem to work, at least it stopped complaining ^^ Create in destination database this function:

   CREATE FUNCTION fn_diagramobjects()
   RETURNS [int]
   WITH EXECUTE AS 'dbo'
   AS 
   BEGIN
       RETURN 255;
   END

Upvotes: 0

Daniel Elliott
Daniel Elliott

Reputation: 22867

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

Upvotes: 5

Daniel Lee
Daniel Lee

Reputation: 7979

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.

Upvotes: 14

user202765
user202765

Reputation:

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.

Upvotes: 2

Robert Kafarski
Robert Kafarski

Reputation: 11

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

Upvotes: 1

Related Questions