You clearly need to unencrypt this as it has not been recorded in any documentation or change process, whatever method you use I recommend documenting and scripting into your change...

Nice simple easy to follow article, thank you Steve. Just one observation; where is the link to your sample code?

Cheers Steve but  a bit of a typo in this one too, cut and paste have a lot to answer for!!

Have you followed up also on Steve's advice on your other post here it may be of assistance.

Synonyms can be defined for servers up to SQL2017 which includes SQL2012, the syntax has not changed, or do you mean something else?

Continuing the theme, but this time with the added bonus of not only a syntax error but also the number of columns appear different! Must be all that Christmas Cheer!! Thanks...

Thanks Steve, detecting a bit of a theme here!

LOL, thanks Steve and Happy Christmas.

Would this not benefit from using a tally table? It would save the loops and missing IDs could be simply omitted?

Been using copy-only for 10 years without issue. They are good for having a point in time backup without affecting the normal restore schedule, so as to have a backup...

Good back to basics question thanks Steve.