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 ....

 

After I notified the devs yesterday, the article states V17, they are going to test that today.

 

FWIW: We re-installed the OS and rebuilt the cluster.

Now it works as it should

 

indeed.

Those settings have been activated.

DTC service has been stopped and started and is on network service

Still Begin distributed transaction fails

Strong suggestion, don't store the images in the database. Can you? Yes. VARBINARY(MAX) would be the way to go. However, it really negatively impacts a whole slew of...

because it has to validate each and every row of the RLS object before it is to be processed by your query

• I avoid images in SQLServer and store their file system path in...

It's called ROW level security for a reason !

So RLS introduces additional processing overhead as the database engine needs to evaluate security predicates for each row.

Of course this...

Pay attention to file / folder security

Start with preparing your new drive ( physical / logical ) by copying the existing folder structures, including their ACL

e.g.

rem especially...

LOL, they don't want their MD to see what illness they have but want to have a treatment for a cure

If you don't trust your DBA, outsource the system and...