Just to get you back on track ...

How many rows do you expect from your nested select(s) ?

SELECT Description + ' ' FROM RawDataDescriptions FOR XML PATH(''))...

Have a look at Powershell module DBATools - Copy-DBALogin

Did you try to run this NOT using MERGE ?

ref: https://michaeljswart.com/2021/08/what-to-avoid-if-you-want-to-use-merge/

Did you check the "Restore ... with standby" option ?

BOL ref: RESTORE ... With Standby

Default trace holds the information you seek ! ( as long as it did not get cleaned up after a number of rolled forward for the xe files )

Have a look at Copy-DBATable of the ( free ) DBATools module in Powershell

same as with an on-prem Sql server instance

I've been testing a bit to detect such queries at the linked server itself ...

For me, it turns out the only actual way to detect it is when you have...

Start an appropriate XE session to monitor that sproc's execution

You need to debug this sproc, because it will hit some error somewhere and may not hand it over to the...

You already made my day, Jeff !

Visualising your figurative speech.

Guess what: our auditors are always charmed by the 2 year migration rule ( that is already active for 10 years...

Eeasiest would be to start adding a partition for the new month and go from there on.

You'll need to handle the 6-month partition adequately in your cleanup process. ( Leave...

O, this is a nice solution track.

It will need some fiddling with, because it spews a load of "ole%" events.

I've ended up with this to start discovering it all:

This reply was modified 2 years, 4 months ago by Johan Bijnens.