Had to roll back...
The ALTER TABLE statement conflicted with the FOREIGN KEY constraint "FK_cs_Referrals_cs_Urls". The conflict occurred in database "msmvps-cs", table "dbo.cs_Urls", column 'UrlID'.
Rolled back to CS 2007 as hitting an error in the upgrade. Will hire someone to do this upgrade.