Removing DB issue

Issue #31 new
Maxim Novikov created an issue

If there is a database currently opened in the plugin window (and you searched through it), I cannot remove that database and need to use this shit first: alter database MyDB set single_user with rollback immediate Looks like the plugin acquired the connection for itself. Is it possible to manage that more appropriately somehow? Either not to keep the SQL connection or handle "removing DB" event if such one exists?

Comments (26)

  1. alex empty

    Max, have you verified that this does not happen if Hunting Dog is off (i.e. Hunting Dog is the one who holds connection???)

  2. Maxim Novikov reporter

    Yes.

    Try the following cases:

    1. Create "test" database using Object Explorer
    2. Remove "test" database using Object Explorer

    [Succeeded]

    1. Create "test" database using Object Explorer
    2. Open HuntingDog
    3. Click "Refresh" button in HuntingDog
    4. Select "test" database in the combo box
    5. Remove "test" database using Object Explorer

    [Succeeded]

    1. Create "test" database using Object Explorer
    2. Open HuntingDog
    3. Click "Refresh" button in HuntingDog
    4. Select "test" database in the combo box
    5. Enter "123" in the search field (you should see "No results were found")
    6. Remove "test" database using Object Explorer

    [Failed]

  3. Maxim Novikov reporter

    Related to #32. Again, maybe it's not that hard to do the same for databases as you have implemented for servers...

  4. Log in to comment