Dynamics GP Error - Cannot drop the index 'taErrorCode.AK2taErrorCode' because it does not exist or you do not have permission

So you are upgrading GP and get the below error.

This is due to a missing index.

Script one out from a working machine and script into your 'troubled' environment. Be sure to also script in the primary key as well in case it is also missing.