Sorry for my slow reply.

I created the user from login. At the server and database level they are only in the public role and I can't see anything relevant allocated...

I am not 100% sure but I think the problem might be as follows:

The log file from the primary server isn't applying to the secondary server which will cause the...

All,

Apologies for my slow reply. Thank you for your help.

Does the WSFC tell you why it fails to bring the AG resource online? I haven't done clustering for a while but I seem to remember there is a log/event...

Thanks for your replies.

In this case there are valid reasons for turning it off. We don't need an unchangeable audit.

I am also looking at using other methods for creating a...

Thank you for the suggestion. Sorry I forgot to mention this possibility in my original...

• This reply was modified 2 years, 5 months ago by as_1234. Reason: Trying to fix quote tags

I can't answer this directly because I haven't used SQL Server 2022 however a question which might help other people answer:

You've said that both databases are getting the same data....

I haven't worked with WSFC/AG for a while and I don't have access to a test system but, if I remember correctly, the WSFC cluster provides a reason why it's...

All,

Thank you for all your advice it is very useful. I have attached the execution plans as txt files

• This reply was modified 4 years, 5 months ago by as_1234. Reason: The site didn't allow me to attach .txt files. So I will try .sqlplan

In addition to the advice above. One thing that might be worth checking, if you haven't done already, is pinging the DNS name and see whether it returns the IP...

Apologises I was thinking that the rows you need to check might all be new or have been updated. As you said it won't pick up existing, unchanged, rows.

Taking a significantly different angle on this and apologises if it's too far outside of the scope of your question but could you use Change Data Capture to identify changed...

Sorry for my mistake. I am having another look at your question and I noticed something:

You said that you need to keep the items marked yellow in your attachment. On...

I think the following might give you the data rows you need?:

declare @sampledata1 table

(

[Date] date ,TC1 varchar(100),Amount_New decimal(10,2)

)
INSERT INTO @sampledata1

([Date]

,[TC1]

,[Amount_New])

VALUES ('2020-11-01','Houses:N-Home',70),

('2020-11-01','Houses:N-KL',80),

('2020-11-01','Default Category: Default Option',90),

('2020-11-01','Houses:NS-Home',22.5),

('2020-11-01','Houses:N-KL',45),

('2020-11-01','Houses:N-GR',22.5),

('2020-12-01','Houses:N-Home',100),

('2020-12-01','Default Category: Default Option',250),

('2020-12-01','Houses:N-Kl',110),

('2020-12-01','Houses:N-Home',24),

('2020-12-01','Houses:N-KL',12),

('2020-12-01','Houses:N-GR',60),

('2020-10-01','Houses:N-BR',24),

('2020-10-01','Houses:N-KL',12),

('2020-10-01','Houses:N-GR',60),

('2020-10-01','Houses:N-BR',24),

('2020-10-01','Default...

People tend to be wary of opening attachments, especially from new users. Can you put the expected result into a post?

It might also help if you can provide test data...