How to force to disconnect a database

Source: Internet
Author: User
When executing the database creation script, the original database is often dropped first. Because SqlServer detects that the dropdatabase operation is prohibited when there is a data connection, the database creation script often fails to be executed, to solve this problem, we need a method to force the database to be disconnected from the existing database. We can use the following t-SQL implementation: declare @ iintdeclarecurcursorfor

When executing the database creation script, the original database is often dropped first. Because SqlServer does not allow the execution of the drop database operation when detecting a data connection, the database creation script often fails to be executed, to solve this problem, we need a method to force the database to be disconnected. You can use the following t-SQL: declare @ I int declare cur cursor

When executing the database creation script, the original database is often dropped first. Because SqlServer does not allow the execution of the drop database operation when detecting a data connection, the database creation script often fails to be executed, to solve this problem, we need a method to force the database to be disconnected from the existing database, which can be achieved through the following t-SQL:

Declare @ I int declare cur cursor for select spid from sysprocesses where db_name (dbid) = 'your _ database_name' open cur fetch next from cur into @ I while @ fetch_status = 0 begin exec ('Kill '+ @ I) fetch next from cur into @ I end close cur deallocate cur

We can write this SQL statement into the batch processing script of the database, and place it at the beginning of the script:

: Disconnect existing Fortune database connections
Osql-S "% 1"-U "% 2"-P "% 3"-Q "declare @ I int declare cur cursor for select spid from sysprocesses where db_name (dbid) = 'your_database_name' open cur fetch next from cur into @ I while @ fetch_status = 0 begin exec ('Kill '+ @ I) fetch next from cur into @ I end close cur deallocate cur"

,

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.