Programatically tell if object has uncommitted changes?

rshahoud

Is it possible to programatically, through .Net code or SQL code, determine if a database object has changes need to be checked into source control? In other words, is it possible to programatically check to see if a given database object name is in the list of changes that haven't yet been checked in on the "SQL Source Control" tab in SSMS? Is there an API call or SQL query that I can use for this purpose? Please advise and thanks in advance!

Sergio R

Hi,

I am afraid that SQL Source Control does not have an API/SDK that would allow you to do this, and it's not possible to do it with a SQL query.
The only way to check the list of changes to commit is interactively through SSMS.

Thank you,