I have been fighting SQL 2022 linked server problems for a couple of days now.

I do not have a satisfactory solution, but according to this Microsoft article, in SQL...

• This reply was modified 5 months, 3 weeks ago by  David Rueter.
• This reply was modified 5 months, 3 weeks ago by  David Rueter.

Thanks for the reply and for the reminder about Monarch:  I remember that from years ago.  It turns out it is still around:  https://web.altair.com/monarch-free-trial

Also, there is an open-source...

As the error message indicates, you must obtain an API Key from Google in order to use this service.  See:  https://developers.google.com/maps/documentation/geocoding/get-api-key

Obtain a key, and then edit the SQL code to...

Thanks, Phil:  EXCEPT and INTERSECT look like the way to go.  I recall reading about them but had never actually used them.

A very old thread...but it still comes up when searching for this problem.

As the first line of the trigger, add

SET XACT_ABORT OFF;

Then you can trap errors in...

This might be a good time for a plug for my SQLVer Version Tracking article.  (It might be time for me to write a new article on this that...

Regarding CREATE vs. ALTER...maybe it is just personal taste, but I don't mind--or maybe even like--the two different commands.  We are not just declaring a procedure (or a function, or...

A good recommendation is to have a simple, but useful header that you use to document the purpose of your procedure and then include comments in places where you...

The link to the SQL script is in the Resources link at the bottom of the story.

That link goes to:  http://www.sqlservercentral.com/Files/Geocode.sql/6085.sql ...but that URL might not...

Thanks, Steve.  In this case, the scenario that I described is a bit of an over-simplification.  The actual use is deep inside a user-configurable enterprise-class application with automatically-generated CRUD procedures...

Ah, thanks.  That helps,  So to refine the description of the problem:

The compile of the stored procedure fails if an int or uniqueidentifier is passed in.  The compile...

A non-visual terminator could be a good solution:  \0 (non-visible null aka CHAR(0) ) could work... but certain systems may treat the null as the end of a string or file,...

You should be able to append the API key to the URL.

See:  https://developers.google.com/maps/documentation/geocoding/get-api-key

Specifically: 

Step 2: Add the API key to your applicationWhen loading...