• John Mitchell-245523 (12/2/2016)


    Or this:ALTER DATABASE SQLTRIX SET SINGLE_USER WITH ROLLBACK IMMEDIATE

    You can use RESTRICTED USER instead of SINGLE USER if that's more appropriate (in other words if none of the processes that are likely to connect to the database will do so as db_owner or higher).

    John

    Do you have any issues of another process getting in there or does the system make the process the SINGLE USER?

    412-977-3526 call/text