What are the challenges you face when working across database platforms? Take the survey
Options

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) 

Answers

Sign In or Register to comment.