now that europe is lagging behind, it is mainly a question of which "partner" you trust most.

Since partnership is being smashed to pieces lately, foundations are shaking, but opportunities are...

Here's a nice overview:

with    ctePartRangesFULL
                  as (
...

Of course, best is to modify the connection strings ( over time )

• Depending on the number of client machines, you could deploy a sqlclient alias to redirect the sqlserver\instance...

My 2ct ( these prerequisites may have evolved over time. U used it a couple of years ago )

1. Did you grant AzureAD/Microsoft Entra to be used with this AzureSQLDB...

check the sql server errorlog file for more information.

( you can find that path in the sql server service startup information )

Replying the above line resulted in

"504 Gateway Time-out

The server didn't respond in time. "

Altough the reply is already registered in SSC.

Except for replying, is there something else we should pay attention to?

For your deadlock graph to be usable, you need to remove:

<event name="xml_deadlock_report" package="sqlserver" timestamp="2025-03-04T15:16:17.973Z">
  <data name="xml_report">
    <value>
Keep the rest
Remove the bottom
  ...

Tools like Solarwinds SQL Sentry PlanExplorer (free) can help you analyse this situation !

It helps you narrow down the 2 tables that are to be addressed to solve the...

your deadlock graph xml is incomplete !

 

Did you register the SPN up front ? ( We always do, because we do not rely on dynamic port numbers for an instance )

If not:

• If you rely on...

Testing a bit more, it turns out, once you add a clustered MSDTC resource and remove it, it start throwing this error when running "Begin Distributed Transaction"

Even putting back...

The example is not correct !

I copied your scripts to my SQL2019 CU31 and executed them.

This is the result I get:

March 3, 2025 at 8:52 am

#4549840

DBCC clonedatabase does not support Ledger !

ref: https://learn.microsoft.com/en-us/sql/relational-databases/security/ledger/ledger-limits?view=sql-server-ver16#ledger-table-considerations-and-limitations

it was worth a try ....