This will only handle if there is only single AAG. I am facing the issue with multiple AAG groups and AAG resides on multiple replicas making it primary due to...

I need a code which will check the AAG name and its role , if it is primary then all the jobs status will enabled else disabled. We have multiple...

Yep we also fixed the similar issue by following 2 steps-

1.Modify the path in the job after failover manually

2.Copy the 110\Tools\Binn\*.* to the single location making the path even

I...

Please support

thanks for the info

Please help to solve this issue as this is PROD Crititical

no update from connect. Please suggest.

Thank you so much , I am not sure what is raising a Connect item (as Koen suggests).

@Koen, Please help me more here.

Yes after doing index rebuild and update stats deadlock get control for few hours and than once again we started to see and job get fail.

Is this a BUG...

Please share your update as this is critical on PROD

I am facing issue with kerberos delegation and need to register sql service to SPN. As this is on cluster wanted to check with you all if it is good...

Thank you , that is indeed a very good input. I will follow-up on that.

Is there any checklist of steps to follow. I am bit confused as the remote DR...

Thank you , I will follow as you suggested.

Could also please share me script to add the new partition , I am not good with writing script.

as Data loading is a continuous process we are expecting high volume data in future. t will be difficult to create these partition in advance , hence I was planning...

hmmm, that means I cannot use a lookup function which will on fly create a cluster index and partitioned the tables.

I have to add the column physically to the...