{"action":"created","issue":{"url":"https://api.github.com/repos/ClearMeasure/AliaSQL/issues/13","labels_url":"https://api.github.com/repos/ClearMeasure/AliaSQL/issues/13/labels{/name}","comments_url":"https://api.github.com/repos/ClearMeasure/AliaSQL/issues/13/comments","events_url":"https://api.github.com/repos/ClearMeasure/AliaSQL/issues/13/events","html_url":"https://github.com/ClearMeasure/AliaSQL/issues/13","id":120013757,"number":13,"title":"Process remains in SQL Server","user":{"login":"eleite77","id":12936399,"avatar_url":"https://avatars.githubusercontent.com/u/12936399?v=3","gravatar_id":"","url":"https://api.github.com/users/eleite77","html_url":"https://github.com/eleite77","followers_url":"https://api.github.com/users/eleite77/followers","following_url":"https://api.github.com/users/eleite77/following{/other_user}","gists_url":"https://api.github.com/users/eleite77/gists{/gist_id}","starred_url":"https://api.github.com/users/eleite77/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/eleite77/subscriptions","organizations_url":"https://api.github.com/users/eleite77/orgs","repos_url":"https://api.github.com/users/eleite77/repos","events_url":"https://api.github.com/users/eleite77/events{/privacy}","received_events_url":"https://api.github.com/users/eleite77/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":2,"created_at":"2015-12-02T19:08:44Z","updated_at":"2015-12-02T19:55:06Z","closed_at":"2015-12-02T19:50:20Z","body":"When we execute it the process remains in the server so we have to kill it manually through the SQL Management console"},"comment":{"url":"https://api.github.com/repos/ClearMeasure/AliaSQL/issues/comments/161414334","html_url":"https://github.com/ClearMeasure/AliaSQL/issues/13#issuecomment-161414334","issue_url":"https://api.github.com/repos/ClearMeasure/AliaSQL/issues/13","id":161414334,"user":{"login":"eleite77","id":12936399,"avatar_url":"https://avatars.githubusercontent.com/u/12936399?v=3","gravatar_id":"","url":"https://api.github.com/users/eleite77","html_url":"https://github.com/eleite77","followers_url":"https://api.github.com/users/eleite77/followers","following_url":"https://api.github.com/users/eleite77/following{/other_user}","gists_url":"https://api.github.com/users/eleite77/gists{/gist_id}","starred_url":"https://api.github.com/users/eleite77/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/eleite77/subscriptions","organizations_url":"https://api.github.com/users/eleite77/orgs","repos_url":"https://api.github.com/users/eleite77/repos","events_url":"https://api.github.com/users/eleite77/events{/privacy}","received_events_url":"https://api.github.com/users/eleite77/received_events","type":"User","site_admin":false},"created_at":"2015-12-02T19:55:06Z","updated_at":"2015-12-02T19:55:06Z","body":"thanks for your reply :-)\r\n\r\ni put some code in my application_start because i want to check the db each time a user is accessing the platform\r\n\r\nbut the process lock the DB while it is on the task list in SQL Server 2014 Express edition\r\ni can't for example drop the db or rename it. But can of course insert data, etc\r\n\r\ni try to use the call in a using () {} statement but it is not possible as the object is not heriting IDispose\r\n\r\nthanks for your help"}}