Monthly Archives: October 2008

November Issue of TechNet Magazine: IT Toolbox

The November issue of TechNet Magazine is out on the website.  Check out my IT Toolbox column here: http://technet.microsoft.com/en-us/magazine/cc987540.aspx In this issue I covered: Altova’s MapForce – Map Data Graphically Expresso – Create and Manage Regular Expressions Active Directory Query … Continue reading

Posted in Microsoft TechNet | Leave a comment

How to put a database into Single User Mode with T-SQL

You can easily put a database into or take it out of single user mode with the following T-SQL:   ALTER DATABASE [MyDatabase] SET SINGLE_USER WITH NO_WAIT GO   ALTER DATABASE [MyDatabase] SET MULTI_USER WITH NO_WAIT GO

Posted in MS SQL Server | Leave a comment