Using SQL Server 2008 and later, I want to add a rowversion column to a large table however when I simply
ALTER TABLE [Tablename] ADD Rowversion [Rowversion] NOT NULL
Then the table is unavailable for updates for too long.
What strategies can I use to reduce this downtime? I'll consider anything. The simpler the better of course, but I'll consider any strategy.