odd part it did one gave this error on next row, so 5 updates and 5 errors

Ok got closer here is code below issue is there are 10 records, it only does 5 (cursor select shows 10).  Odd error message also

Msg 7202, Level 11, State 2,...

no rollback

One anomaly seems to be the query store, it had flipped to read only (there was plenty of space left on disk but the store was a max level...

no help

tried that already index rebuild happened 2 days before.  Bad plan all of a sudden chose wrong index went from a few thousand to over 600K reads.  This happened a...

no not a failover, I understand that tempdb actually holds indexes for this server when being used (which is great until reboot)

AG would be Always On which would require Enterprise, if you can swing it (want to be on at 2014 2016 if you can).  When setting up you restore the...

hate to ask is this for just reporting from databases from server b thru server a?  If so wouldnt a AG read only node be better?  Also is this all...

also remember windows users will be different than sql logins you can get the dreaded mismatch with the sids

sorry may have found it query store was set to read only not read write, database is regular oltp database

that is what I concluded dealing with vendor the day before a holiday not always the best time for answers

should have clarified, the deadlocks and blocking I get are on the OLTP database Biztalk communicates with not the BizTalk native databases

close only issue is I am looking for any statement, not just sp's (SSIS) that do the update, will see if I can tweak it

other choice was an active passive cluster with AG for the read only node.   interested in how many people have tried that approach

thanks only question is when replicated to the RO server isn't there a need for the login to mapped to the SID?  Actually going to try this with test AD...