Between the time that a Changeset has been begun by up_Changeset_begin and ended by up_Changeset_end it is marked as active and associated with a SQL Server transaction by having a record in this table. When Changesets are used as designed there will never be records for them in this table visible outside of the transaction. If the database is changed outside of the application or without properly beginning and ending a changeset, a changeset may be automatically created and will not be ended, so records will be visible in this table for those changesets. It is safe to delete these stranded records from Changeset_Active. |