Script to grab single user mode and set back to multi user. Useful in event of DB in single user but something like polling service grabs connection.

EscapeSingleUser.sql

-- Check user with access
SELECT
    p.loginame
FROM
    sys.databases d
    inner join sys.sysprocesses p ON (d.database_id = p.[dbid])
WHERE
    d.name = 'database_name'

-- Try to grab database 1000 times
Use [database_name]
GO 1000
 
 
-- Set database to multi user mode
ALTER DATABASE [database_name] SET MULTI_USER;