Tuesday, May 23, 2006

One of the products I help to look after has recently gained its own upgrade process - so you put in the CD and "stuff just happens". As part of this the database gets upgraded, and whilst doing so it is put into single user mode. Unfortunately, one customer has had a problem, and the upgrade has failed. We thought it might be in single user mode, but weren't convinced, so to check we ran


sp_dboption [databasename], 'single user'


which resulted in


OptionName   CurrentSetting
-----------  --------------
single user  on


to change this we simple issued


sp_dboption [databasename], 'single user', false


and checked again and this time it said


OptionName   CurrentSetting
-----------  --------------
single user  off


Success! Now to fix the process...

Labels: Development, SQLServer

// posted by Jane @ 1:58 PM