Is there a function like min_active_rowversion for Identity?
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ margin-bottom:0;
}
0
I'm storing a queue of events in Sql Server with concurrent writers and I'm assigning a sequence number using an IDENTITY column. I'm willing to accept the gaps that might occur, but I would like readers not to read past the minimum identity active in any uncomitted transaction... like what I can do with min_active_rowversion for ROWVERSION columns. Is this possible?
sql-server
share | improve this question
asked 11 mins ago
asgerhallas asgerhall...