Post reply

switched to restricted user

  • September 27, 2005 at 4:29 am

    #91436

    Anybody got an idea of the below given message?

    'The database was being switched to restricted user every five minutes, which made every connection in the connection pool invalid'

    Regards

    Rajesh

     

  • September 27, 2005 at 9:31 am

    #593326

    This is a strange, I don't think anybody or job could beable to set database user mode while there are lots of connection open.  You could change it only when there are no other open connection on that database.

     

    mom

  • September 28, 2005 at 5:29 am

    #593601

    The alter database command will allow you to do this and will kick your users out of the database. You'll need to profile the server I suspect. I believe certain maint tasks can run commands which might attempt to put the database into single user mode - one reason why I don't ever use sysmaint.exe jobs!!

    [font="Comic Sans MS"]The GrumpyOldDBA[/font]
    www.grumpyolddba.co.uk
    http://sqlblogcasts.com/blogs/grumpyolddba/

  • September 28, 2005 at 7:45 am

    #593667

    Are you using application role?

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply