If I understood well, a natural join is supposed to have no ON-clause as it uses matching column names

ref: https://www.geeksforgeeks.org/sql-natural-join/

Are all your sql server 2016 instances upgraded up to the latest sp/cu ?

Keep in mind, to be able to see the tables relationships, you need to be granted "View Definition" at database level

GRANT view definition TO [youraccount/group]

What do you mean with "second occurrence of a character" ?

I cannot see that in your "Left(Replace..." example.

Have you seen these questions/articles ?

• "removereplace-string-after-specific-character"
• "Split String Function"
• "

1. you are connected to a database !
2. You specify a table or view in a query
3. Via SSMS Object browser, you can rightclick and generate "select" or "edit" for...

UPDATE sn
   SET 
       sn.delay = CASE
            ...

• This reply was modified 3 years, 8 months ago by Johan Bijnens.

I hope you rebooted your computer between uninstall and install

The sqljob proxy account ( or sqlagent service account is no proxy account is used ) needs to be granted the needed authority to run the script.

Don't use "C:\Users\..." as...

QueryStore ( if activated ) holds that data, but it does not hold the SQLagent context.

What's the version of your SQL2019 ? ( latest CU ? )

Did you try setting the db level to 150 ?

Another option is to test the database configuration setting...

Did you grant the cluster service account ?

ref: "A Step by Step Guide to the Availability Group (AG) Listener"

no, it does *not* mark downstream objects to be recompiled too!

Check my little article to get you started:

"Logon monitoring in SQL Server and Azure Managed Instances - Adopting Extended Events"

Select Avg(datediff(ss, Start_time , End_time )) as avg_time_duration_in_Seconds From table

I've had my Azure dev write an Azure Logic App to remove files of a given container path after 30 days.