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

JxChillin · November 30, 2023 8:00PM

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)

David Atkinson · November 30, 2023 9:45PM

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?

JxChillin · December 1, 2023 12:52PM

David Atkinson said:

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.

David Atkinson · December 1, 2023 3:04PM

Interesting. What is the consequence of two users changing the same query?

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

Answers

Product Learning

Community Forums

Events & Friends

Simple Talk