You have to make sure the folder level permisson are correct where replication schemas are stored during snapshot job .

Check all the distribution job owner if they are...

Sorry for multiple posts , I promise this was unintentional blame to my browser's Friday mood .

What is the error you are facing , you can alter the Table if there is no index exists on the column you are altering and if any index exists...

[font="Verdana"]What is the error you are facing , you can alter the Table if there is no index exists on the column you are altering and if any index exists...

[font="Verdana"]What is the error you are facing , you can alter the Table if there is no index exists on the column you are altering and if any index exists...

You can not alter the table with out dropping and re-adding them , having distribution job running or not is irrelevant .

Steps to follow :

1. Remove the Table...

Its better to manage using another subscription as it helps better in managing and future troubleshooting with out hampering other department's data availability .

Keep the factor of Data size...

Is the application using any middle tier like Tibco ?

Good to know !

Thanks , this helped 🙂 . I will check to add to loop through all the indexes in the table .

If you want to check only Latency you can find it using tracer token or use below commands .

1. sp_replmonitorsubscriptionpendingcmds

2. sp_replmonitorhelpsubscription

What is the Security context configured in the Linked server.

It should be ideally , what you see when query mssubscription for the same database .

For this can you first check the security context of the both the servers and check the test connection .

Any resolution found for this issue .