How can we improve SQL Source Control?

Keeping history of locked and unlocked objects

Locking feature doesn't keep history of who has locked or unlocked specific objects in database. This could become useful when a person unlocks an object locked not by him/her and would help to track historical changes.

It would require very few changes - additional history table,

[SQLSourceControl].[LockObject] and [SQLSourceControl].[UnlockObject] procedures would have to be modified.

Possibly an additional view to see that data in SQL Source Control instead of selecting raw tables.

3 votes
Vote
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    Evaldas shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    1 comment

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)
      Submitting...
      • Ken commented  ·   ·  Flag as inappropriate

        That's a great idea. I was looking for something similar but didn't see any history. If I locked an object and if someone decided to unlock and overwrite my changes, I like to know who unlocked it.

      Feedback and Knowledge Base