Post reply

Lock specific users during Database Update

  • November 26, 2005 at 12:47 am

    #111402

    Hello Everybody.

    I'm in charge with SQL 2000 DB Administration.

    In my perimeter there is a database updating by a jobstream.Unfortunately the jobstrem is frozen when some users access to the DB in the same time

    Iwould like to lock ,by an sql command or a store procedure,these specefic users during the jobstream by a script and open the connection when the jobstream is finished.

    The lock should be for a given users because if I apply for all users ,the user making the update , inise the jobstream, will be locked too.

    Do you think that it is possible

    Regards Almystic

  • November 28, 2005 at 1:29 am

    #606017

    Your Job script could set the database to single user, perform it's update and set the database back to normal mode. This would require that it could set single user and would need to loop trying until it could.

    Andy

  • November 28, 2005 at 3:08 am

    #606024

    Thaks Andy.

    I will try taht and I will keep you posted aboutthe results

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

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