This proc was used in a one time push to change tables with uniqueidentifier PK to have a BIGINT IDENTITY(1,1) PK instead.
It's easy to customize this script for any datatypes you want. You can change the query to sys.all_columns to look for a different user_type_id if you need to run this sort of script for different PK datatypes. Also, you can change the new PK datatype in the SQL code that adds 'RowID'.
