Thank you!

FCI, 2 nodes, (current active node A) we failover and leave all services including mssqlserver on Node B. Transactional replication will break, we have to set it up using the...

Can you paste XML plan or and Graphical Ex. Plan?

@Grant, I am having same issue. Execution plan "Output List' says 3 columns, col1, 2 and 3 above that Object" is 'PK_id'.

I understand if you add those columns to a...

Hi VoldemarG,

Do you mind sharing your whole script/store proc? Thanks

Thanks a lot Scott for you reply. Do you recommend RCSI is on?

Thanks Jeff!

Thanks Eddie for your kind reply.

Thanks Jeff for your kind reply. One think in my mind is even if there is/are table or index scans, shouldn't  'sys.dm_exec_query_stats' shows you very high on columns like  '_grant_kb'...

Just my 2 cents. It seems to me that Index 'Rebuild' job was aborted and caused the timed out and rolled back. I had also experienced 'out of sync' secondary....

You can try:

Execute as 'sa'

How can I execute the script from another server using 'Linked server'? I added 'linked server ' below after EXEC but not working!!! Another word I have a below sql...

Thanks Jeff for the info. Appreciate it!!

Thanks Syed for taking time to reply my question. It does make sense but I am looking for some kind of script to show.

Yes, Jeff.