September 26, 2008 at 6:15 am
My database is hosted on SQL 2000 server; our database was initially configured as multi user mode but from time to time it gets "stuck" in Single User mode ,knowing there is no backups done over such database. The cleanup of this is going to the Options tab of the database properties and unchecking Restrict Access but that doesn't remove the issue in the long run. This doesn't happen often, perhaps once a month, but there has been no discernable pattern to the problem so I don't know why its happening.
And as a note I have build a script for creating such database , and by this script I have created this database on multi servers and this problem is generated only at one server . I need to know how could I trace such problem , or at least know the general reasons for sudden change in user mode.
Thanks
September 26, 2008 at 6:37 am
Just a quick question, Do you know whatis causing your db to be put into single user mode? I would guess a job or something is putting the db into single user mode...
Gethyn Elliswww.gethynellis.com
September 26, 2008 at 7:02 am
I searched syscomments in my database for text having pattern %sp_dboption% or %single_user% to know if there is any comment related to such point but nothing is returned. Actually i don't think we have a procedure that tries to alter user mode , all stored procedures and jobs performs functionalities as data retrieval , data insertion and others.
Is there any system stored procedure that may affect user mode?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply