Thank you so much! I just didn't use my brain when I attempted this. I did not set the variable to the connection I wanted so that's why...

Thank you!!

MD - Could you please dumb-it-down for me please? :/ I'm not sure how to do "dynamic SQL" nor "dynamic connections"... I'm sorry...

Thank you!

Matt Miller - It doesn't seem that the "dbcc checkident(CMS_3a, RESEED, @max1)" is working. The IDs are still starting at 1, not 237526 (which is the current max...

Thank you for the suggestions!

GSquared - Thank you. I didn't know about the row_number() function and now I know a little more about it. However, I still cannot...

Thank you for the replies!

Lynn Pettis - The reason I'm using an alter statement is because I wanted to add the "cwid" column with an identity seed starting...