Blog Stats
  • Posts - 94
  • Articles - 0
  • Comments - 10
  • Trackbacks - 0

 

October 2008 Entries

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 - Query and Navigate Active Directory Crimeware: Understanding New Attacks and Defenses (Book)

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

 

 

Copyright © Greg Steen