REALLY??? WOW.. I have written a fair amount in the past however this is by far the largest dynamic project I have worked and in effect reverse engineers the relationship portions of SQL in order to migrate multiple databases into a single DB; all the same structure.

Obviously the GUID fields are a pass through however IDENTITY columns are renumbered and I have to keep track of the OLD and NEW values for proper mapping for the dependent tables.

Thanks for the Heads up. I am not using SYSNAME often here and I would have to look at this proc to see if I am using it at all. I know that I am in some procs so this is good to know.

That sounds strange because after you append the data it is just data without a datatype outside of the field it is being appended to.

I am using varchar rather than nvarchar as it is longer. I will have to lookup the length of the nvarchar type. Does it follow the same rule? Basically half the characters as a varchar? So a nvarchar(max) would be like 1.3 terabytes? (rhetorical question really, I will look it up 🙂 )