New answers tagged

2 votes
Accepted

SQL 2019 High Availability Stored proc issue on secondary server

I recommend a change in your process. Move the Primary check logic out of the procedure into the first step of the job. If the step fails, quit the job reporting success. This way, no other steps are ...
user avatar
  • 1,865

Top 50 recent answers are included