Changed by "Unknown" when using Changelog
But even though the RG_AllObjects table contains an entry for a modification to an object (table) and the correct username indicating who modified it, the "commit changes" tab shows the object as changed by "unknown".
It would appear that until we commit this object, whatever further changes we do to this object will not cause the "unknown" to be replaced with a username.
What we are finding is that many of our uncommited changes eventually end up with "unknown" against them as further modifications are made to the original object in areas that SSC does not currently support in change logging.
For example, a straight table creation will initially correctly show the user who created the table but a subsequent addition of a default constraint will cause the username to be replaced by unknown in the commit changes window (although the username will remain in the changelog table). All further table schema changes will not alter this situation until after the object is commited to our source control system (svn).
Could you explain this behaviour and specifically why when the username is corrrectly stored in the change log db, it is not appearing in the commit changes window? Thanks.