Enabling super single user mode with SQL Server

Posted by simonsabin on SQL Blogcasts See other posts from SQL Blogcasts or by simonsabin
Published on Fri, 26 Mar 2010 18:21:33 GMT Indexed on 2010/03/26 19:03 UTC
Read the original article Hit count: 226

I recently got an email from a fellow MVP about single user mode. It made me think about some features I had just been looking at and so I started playing. The annoyance about single user mode for SQL Server is that its not really single user, but more like single connection mode. So how can you get round it, well there is extension to the -m startup option that allows you to specify an application name, and only connections with that application name can connect. This is very useful if you have...(read more)

© SQL Blogcasts or respective owner

Related posts about SQL Server 2005

Related posts about Tips and Tricks