Post reply

SQL Server 2005->Problems while changing restrict access property from Restricted_User to MULTI_User

  • May 5, 2009 at 1:26 pm

    #384507

    Hi

    I am not able to change the restrict access property from Restricted_User to MULTI_User.

    I have tried both from Management Studio as well as writing Query

    ALTER DATABASE rtcdyn SET MULTI_USER

    Everytime I am getting error :"Lock request time out period exceeded."

    "ALTER DATABASE statement failed."

    Please note I have the SQL Admin rights.

    Thanks,

    Jeet

  • May 5, 2009 at 3:41 pm

    #989241

    I got the Answer ...

    We need to kill the existing connection..

    In order to do that the best way is to follow these steps:

    1.Right Click on the database.

    2.Click to detach the database

    3.Click on the active connections

    4.Kill the connections.

    Then run the ALTER database Statement to change the Restric Access property of the Database.

Viewing 2 posts - 1 through 1 (of 1 total)

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