This looks more like a flowchart than a stored procedure. Everything just calls something else. And how are you anticipating this returning something to the client? This whole thing just...

I have at least briefly mentioned my past as a punk rock musician in Lawrence, KS in the late 80s. The place where most of the shows were at that...

You have a procedure in Apples that inserts into the Users table on another database correct? I don't see how that would cause an issue with identity values. Or maybe...

You have obfuscated this problem so much it is really hard to tell what the issue is. Does the Users table exist in both databases? I can't even get close...