The Blog of Matthew Baxter-Reynolds

On May 24th, Microsoft are introducing a new tier to Action Pack licensing that grants developers VS 2010 and MSDN Essentials licensing. It’s dubbed “Microsoft Action Pack Development and Design” and more details can be found here.

Had a good one today – we decided to add optimistic concurrency at a framework level to every table in a client’s application, and to do that we had to add the same column to 100+ tables.

Again sp_msforeachtable saved the day:

EXEC sp_msforeachtable
‘ALTER TABLE ? ADD RowVersion int DEFAULT 0;’ ;

A handy hint via Steve Smith: http://stevesmithblog.com/blog/open-visual-studio-files-as-administrator/…