Showing posts with label mssql 2000. Show all posts
Showing posts with label mssql 2000. Show all posts

Saturday, December 29, 2012

Remove Single User Mode From Your MSSQL Database

***This guide is valid for MSSQL 2000, MSSQL 2005, MSSQL 2008 and MSSQL 2012. 

Is your database stuck in single user mode? Irritating isn't it? Use the following command to restore it to normal service, where DBNAME is the name of the database:

exec sp_dboption 'DBNAME', 'single user', 'FALSE'
go

Billing systems development now available

Good news for current and future clients of Josh Wieder Technical Consulting : customers can now retain a variety of unique services related...