Changing multiple Queries connection in a Project

  • If you have a project that have multiple queries and multiple connections, is there a way to change all my queries to use one of my defined connections?

    I have about 20 queries in my project and when I go home or to work I have to manually do each query to change the connection.

    Also, I have set up my connections with my default database in the connections section of the project. But I don't see the point. When you change the connection, it comes up with the normal connection dialog box. So when I do that, it goes straight to master. So what was the point in setting up connections in the project?

    Is there around these issues?

    Thanks,

    Tom

  • What kind of project are we talking about here?

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • Sql Server Management Server project.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply