How can we help you today? How can we help you today?

Closing Connections

HI. I just installed Sql Prompt and I'm not quite sure what the documentation below refers to. If I am in query anaylzyer and exit, the database connection is closed automatically. So i'm confused as to when I would use this button.

Closing connections
You can free up the resources that SQL Prompt is using on your SQL Servers by closing SQL Prompt's database connections. You do this by clicking Close All Current Connections.

Note that you should close SQL Prompt's database connections when you restore a database.

Thank you,
Juanita
Juanita
0

Comments

3 comments

Sort by
  • Tilman
    Hi Juanita,

    thanks for your question. While Query Analyzer is running, SQL Prompt always has an open connection to SQL Server to retrieve schema information of individual objects. This is not a problem in most cases, however, for some operations SQL Server requires exclusive access to a database. For example, when you want to delete a database, or when you want to restore it from a backup. To be able to do this, without closing down SQL Prompt, we have included the Close all connections button.

    Regards,

    Tilman
    Tilman
    0
  • Juanita
    HI. So if I am doing typical queries with select, udpate, and delete statements, then I do not have to use this 'close connections' button? My connection will close when i close Query Analyzer?

    Thanks again,
    Juanita
    Juanita
    0
  • Tilman
    Hi Juanita,

    Yes, queries, inserts and updates will work without having to close the connection to SQL Prompt, as will most other operations. It's just a few cases in which SQL Server requires exclusive access to a database.

    I'm afraid SQL Prompt will keep the connection open, even after you have exited Query Analyzer. This is of course not ideal, and we will fix it for version 3.

    Regards,

    Tilman
    Tilman
    0

Add comment

Please sign in to leave a comment.