How can we help you today? How can we help you today?

Does Object locking feature with SQL Source Control work for dedicated databases?

I am wondering if the dedicated database will cause issues with object locking in my particular case. 
In my instance all users work on their own copy of the DB and commit changes to source control.

1. If I run the Object Lock query on the database copy that I have, will all other users have to do the same to their copy in order for everyone to be able to use object locking?

2. If I lock a stored procedure are all other users able to unlock this procedure in the even that I am not able to unlock it myself? (emergency situation/ someone is out of office)
JxChillin
0

Comments

3 comments

Sort by
  • David Atkinson
    Object locking is to prevent multiple users changing the same objects in a shared database context. In dedicated databases, this can't happen. What were you hoping it would prevent?
    David Atkinson
    0
  • JxChillin
    Object locking is to prevent multiple users changing the same objects in a shared database context. In dedicated databases, this can't happen. What were you hoping it would prevent?
    I was hoping it would keep users from making changes to the same query at the same time.
    JxChillin
    0
  • David Atkinson
    Interesting. What is the consequence of two users changing the same query?
    David Atkinson
    0

Add comment

Please sign in to leave a comment.