How to drop all database connections?

Accepted answer

Restart the SQL server service and run the following script

ALTER
DATABASE mydb SET OFFLINE WITH ROLLBACK IMMEDIATE

and then run this to run database again.

ALTER DATABASE mydb SET ONLINE WITH ROLLBACK IMMEDIATE

0

Tamer Khalil17y ago

I checked if there is an active process, but nothing was found, and i checked if tried to set AUTO_UPDATE_STATISTICS OFF, but i got the same error.

0

naura pax17y ago

hi you have to check these
is AUTO_UPDATE_STATISTICS_ASYNC option set to on then set it to off and also check if their are any active jobs in the server from
select * from sys.dm_exec_background_job_queue
if there are any jobs then kill them using KILL STATS JOB

0