Can I lock a table only for a specific user for some seconds

  • Hi I ned to do some operations on a table when any user dont work with it.

    How do i do it?

    Do i lock the table? and is it possible?

    (I dont want to deny permission from a user because cause error)

    Can i do it with a open transaction ?

  • Please do not crosspost. It wastes peoples time and fragments replies.

    Original thread with replies can be found here:

    http://www.sqlservercentral.com/Forums/Topic1675257-3411-1.aspx

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • Please do not cross-post, it fragments responses and wastes people's time. Replies here.

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

  • Koen Verbeeck (4/8/2015)


    Please do not crosspost. It wastes peoples time and fragments replies.

    Original thread with replies can be found here:

    http://www.sqlservercentral.com/Forums/Topic1675257-3411-1.aspx

    Wow.

    You just need to learn about apostrophes and we'll be in sync 🙂

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

  • sorry

    yes you are right

    But I write to wrong group and didnot know to change thats group.

    ok thank you

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

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