Post reply

Prevent editing of a table already in use and refresh table for all clients

  • December 17, 2009 at 5:51 am

    #214758

    This has been asked probably a million times but I have not found one clear answer.

    How can I prevent the user from editing a table if another user has it open and

    how can I make the table refresh on all client machines after it has been changed ?

    How do you tell client user the table is in use ?

  • December 17, 2009 at 6:18 am

    #1093453

    Depends if you want optimistic or pessimistic locking.

    Sounds like you want to be pessismistic so sp_applock , may be best for you.

    As for messaging back to a client app that a base table has changed, again depends....

    You may want the clients to continually select from the table where row timestamp > lastchecked or you may want to do something funk with service broker.


    Clear Sky SQL
    My Blog[/url]

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

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