I am a bit confused on the permissions required to execute stored procedure. For example, if you have 2 tables and a stored procedure which reads data from Table1 and...

Thanks a lot guys.

Thanks! Do I need to mention the reason or did by accident would be suffice along with explanation like you said I will research and prevent that from happening again.

I have setup the availability group as below.

Primary Replica - Full, Diff and Log backups & Maintenance Jobs etc.

Secondary Replica 1(Synchronous commit) - For HA and Automatic Failover

Secondary Replica 2...

I followed below link and it is not working when I do the failover.

https://techcommunity.microsoft.com/t5/sql-server-support/setting-up-replication-on-a-database-that-is-part-of-an-alwayson/ba-p/318171

Any thoughts?

Let me rephrase that. I have SQL Server publisher database with server Latin1_General_Bin collation and it is part of availability group. So I will configure remote distribution server to handle...

So I decided to go with remote distribution so that would need additional SQL Server.

Does the collation of the remote distribution server has to match with the publisher? Please advise?

So would you recommend to run update statistics with full scan for the whole database weekly instead of normal update statistics? One thing I noticed when I compared both execution...

Thanks. So the command has to run from the SQL Server installer location?

Thanks. If execute as clause is used means then the store proc's need to be modified right?

Thanks. Can you advise the better option for truncate only table level permission? This particular table will be called in store proc.

On second instance. I think the Polybase Data movement service should be only running not the PolyBase Engine. It should be disabled. Can you restart the polybase Data movement services...

Can you check the polybase services on the second instance?

Half to 90%.