Does Object locking feature with SQL Source Control work for dedicated databases?
JxChillin
Posts: 2 New member
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)
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)
Tagged:
Answers
Product Manager
Redgate Software
Product Manager
Redgate Software