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: 407

Filed under:

SQL Server 2005

|

Tips and Tricks

|

SQL Server 2008

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

VSS 2005 and VS 2005

as seen on Stack Overflow - Search for 'Stack Overflow'
I use VS 2005 and VSS 2005. Every time I close VS I get error: ss.ini not found. But except this VSS works fine, no problems when I open VS and do check in and check out. ss.ini is present and VSS repository specified as network path. I just worry that I can have problems later. >>> More
[MAJ] SQL Server 2005 Express Edition - La version gratuite de SQL Server 2005

as seen on ASP-PHP.net - Search for 'ASP-PHP.net'
Modification technique pour le site de l'article. >>> More
SQL SERVER – Concat Strings in SQL Server using T-SQL – SQL in Sixty Seconds #035 – Video

as seen on SQL Authority - Search for 'SQL Authority'
Concatenating string is one of the most common tasks in SQL Server and every developer has to come across it. We have to concat the string when we have to see the display full name of the person by first name and last name. In this video we will see various methods to concatenate the strings. SQL… >>> More
Displaying the Row Number in a SELECT Query with SQL Server 2005

as seen on Internet.com - Search for 'Internet.com'
SQL Server 2005 introduced a function that is very handy when you want the result set to have row numbers assigned to each returned row. >>> More
Preparing To Upgrade Access Tables to SQL Server 2005/2008

as seen on Internet.com - Search for 'Internet.com'
Garry Robinson discusses some of the subtleties that you can apply to your database tables prior to upsizing your tables to SQL Server. In this article, I will show you how to fix up some of your Access backend before you make the conversion. >>> More

Related posts about Tips and Tricks

3 Tips of SEO That Will Make You Money - Search Engine Optimization Tips

as seen on Ezine Articles - Search for 'Ezine Articles'
You need to make sure your marketing methods rank high in the Google and Yahoo search engines; to do this you're going to need to understand search engine optimization. Here are 3 SEO tips. >>> More
More Linux Tips and Tricks

as seen on Internet.com - Search for 'Internet.com'
we learn how easy it is to configure OpenSSH to use secure public key authentication instead of a password login. >>> More
More Table View Tricks for the iPhone

as seen on Internet.com - Search for 'Internet.com'
Go beyond the basics of the iPhone Table View with examples for grouping rows into sections, displaying an index on the side, and adding a Search Bar. >>> More
More Table View Tricks for the iPhone

as seen on Internet.com - Search for 'Internet.com'
Go beyond the basics of the iPhone Table View with examples for grouping rows into sections, displaying an index on the side, and adding a Search Bar. >>> More
SQL SERVER – Fix : Error 3623 – An invalid floating point operation occurred

as seen on SQL Authority - Search for 'SQL Authority'
Going back in time, I always had a problem with mathematics. It was a great subject and I loved it a lot but I only mastered it after practices a lot. I learned that mathematics problems should be addressed systematically and being verbose is not a trick, I learned to solve any problem. Recently one… >>> More