SCOPE_IDENTITY across Linked Servers

You see…there’s this thing called “scope” and it apparently only applies to the server you’re calling SCOPE_IDENTITY from. Which does make sense in a “I just spent 3 hours fixing my code” kinda way. Wrote a few new stored procedures on the linked server that returned the identity as an output parameter, easy. [...]

Also tagged ,