Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

drop database fails most of the time because the db is in used #949

Closed
llali opened this issue Jul 17, 2017 · 3 comments
Closed

drop database fails most of the time because the db is in used #949

llali opened this issue Jul 17, 2017 · 3 comments
Assignees
Labels

Comments

@llali
Copy link
Member

llali commented Jul 17, 2017

  • MSSQL Extension Version:
  • VSCode Version:
  • OS Version: RHEL

Steps to Reproduce:

  1. Create a new database
  2. Close mssl extension
  3. Open the extension, open new sql query and connect
  4. Execute "Drop database [db name]

Expected: the database should get dropped successfully since there's not any other open window accessing the database

Actual: The query failed: Cannot drop database "[db name]" because it is currently in use.

@llali llali added the Bug label Jul 17, 2017
@kevcunnane kevcunnane added this to the MSSQL 1.2 Release milestone Jul 18, 2017
@kevcunnane
Copy link
Contributor

We can look at this for the next release - we should better handle our open connections and try to ensure this works as well as it does in SSMS

@llali llali self-assigned this Sep 19, 2017
@llali
Copy link
Member Author

llali commented Sep 19, 2017

A change Karl made in sqltoolsservice should be related to this issue. I'll verify to make sure it's really fixed

@llali
Copy link
Member Author

llali commented Sep 19, 2017

fixed in microsoft/sqltoolsservice#460

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

No branches or pull requests

2 participants