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?
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.
Comments
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?
CTO @ Engage IT Services s.r.l.
Database Administrator and Team Leader
Microsoft MVP - Data Platform
Staff member of getlatestversion.it community
personal website | blog
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.
DevOps Mentor and Coach
Director of DLM Consultants
Creator of Speaking Mentors
Microsoft Data Platform MVP
Friend of Redgate
Twitter / LinkedIn