How to force to disconnect a database

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"

,