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

Table of Uncommitted Objects

Is there a table of uncommitted Objects that I can use to send a report to developers to commit there work?
Pat
0

Comments

2 comments

Sort by
  • AlessandroAlpi
    Hi @Pat,
    are you speaking about SQL Source Control and git versioning? When you save the objects, you will see in uncommitted status using git/team explorer. Are you thinking about a tab into SSMS before sending objects to git? You've already the Push/Pull button right now.
    Did I get it?
    AlessandroAlpi
    0
  • AlexYates
    Assuming you are using shared model and that you are looking at the objects listed in the commit tab. If that assumption is incorrect please disregard the rest of this answer an clarify.

    Short answer: No. This list is calculated by comparing dev database to source control and the info about who committed what is pulled from he default trace.

    Longer answer: You could set up an automated SQL Compare job using SQL Compare command line to create a report of the differences between source control and dev database, but this will not have info about who made what changes unless you also cross-reference with default trace, which sounds hard.

    My recommendation: Switch to the dedicated model. Then this problem probably mostly goes away.
    AlexYates
    0

Add comment

Please sign in to leave a comment.