Cannot change the default database reference while designers are open.

You cannot change the default database reference while using the designers to create or modify a query, view, inline function, or stored procedure. This warning occurs in two circumstances:

  • You are changing the default database reference for a folder while some of the folder's documents are still open in the Query and View Designer.

  • You are changing the default database reference for the entire project while some of the project's documents are still open in Query and View Designer.

To correct this error

  • Close the designers and then change the default database reference.