Thank you! That was it. Duh.

Now, I can go into the properties of my DBs and then I click on Options and I can set the...

I use SQL Studio and then Object Explorer to navigate thru SQL. Right after I excuted this command:

ALTER DATABASE TEST SET SINGLE_USER WITH ROLLBACK IMMEDIATE

I could see in Object...

Thanks for the quick reply. But the problem still is I cannot login to the SQL db at all because it's in Single-user mode, so how can I execute...

Hi, I'm having this exact problem. How do you identify the connection that is consuming the single-user connection? Is it 75 by default?

Thanks