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

Question

Post reply

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

MotivateMan1394

Hall of Fame

Points: 3876
More actions
April 8, 2015 at 1:53 am

#295794

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 ?

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

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

Koen Verbeeck SSC Guru Points: 259125 More actions · Answer 1

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

Phil Parkin SSC Guru Points: 246992 More actions · Answer 2

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

The absence of evidence is not evidence of absence.
Martin Rees

You can lead a horse to water, but a pencil must be lead.
Stan Laurel

Phil Parkin SSC Guru Points: 246992 More actions · Answer 3

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 🙂

The absence of evidence is not evidence of absence.
Martin Rees

You can lead a horse to water, but a pencil must be lead.
Stan Laurel

MotivateMan1394 Hall of Fame Points: 3876 More actions · Answer 4

sorry

yes you are right

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

ok thank you