I've come across some new functionality in SSMS that you should be aware of. By default, you can't perform any action, like inserting columns, that forces the table to be recreated. But there's a flag for that. I've put together a short Camtasia just to demonstrate how it works. Hope this helps someone. Download file Watch my free SQL Server Tutorials at: http://MidnightDBA.ITBookworm.com Read my book reviews at I’ve come across some new functionality in SSMS that you should be aware of. By default, you can’t perform any action, like inserting columns, that forces the table to be recreated. But there’s a flag for that. I’ve put together a short Camtasia just to demonstrate how it works.Hope this helps someone. Download file Watch my free SQL Server Tutorials at: https://MidnightDBA.ITBookworm.com Read my book reviews at: www.ITBookworm.com Blog Author of: DBA Rant – https://dbarant.blogspot.com Databases