January 1, 2003 at 10:06 pm
I have a SQL 7 database which keeps reverting to single user mode. I find out when web site viewers inform me of errors, and then I see that in Enterprise Manager it becomes single user access. I have to keep changing it back.
Is there any way to determine how this is happening? I don't think triggers work - books online gives no indication that they can be used for an alter database statement.
Is it possible to write a script to notify me of the change, the user, and the time when the database was changed to single user?
If this is not possible, could anyone suggest how I might be able to write a script to frequently check to see if the db is in single user mode?
Much appreciated from a newbie
Cobba
January 2, 2003 at 4:39 am
Check your maint plan. If you've set the option to repair any errors, it has to put the db in single user mode to do so and there was a bug in the plan where sometimes it would not correctly reset. Until fixed I had a job that ran afterwards to make sure no db was single user.
Andy
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply