Very enlightening for me. Much appreciated.

Br. Kenneth Igiri (7/19/2016)

---

hawg (6/2/2016)

---

Here is an update on what the issue was for me. Exit code 5 is an "access denied" code. The problem had to do...

hawg (6/2/2016)

---

Here is an update on what the issue was for me. Exit code 5 is an "access denied" code. The problem had to do with UAC settings...

Depending on...

I think you should also check row count of the affected tables before and after repair_allow_data_loss.

Taranjit Singh-373811 (7/17/2016)

---

From SQL Server 2014 onwards , MS have changed Cardinality Estimator. This has improved some of the application, while degraded some of the queries drastically leading to roll...

Oh my goodness! I can't believe it. It was McAfee again!!! Been at this all day. Thank so much.

You can get those details at this site, Kailash:...

I should add that you need to "Allow Blocked Content" when opening the resulting HTML file on IE

You need to save the report as HTML then read the report. You will see the issue there. I will post a screen shot shortly.

Thanks all. I eventually solved this by setting the Maximum Failures in the specified period for the Cluster Role which has the same name as my Availability Group to...

Beatrix Kiddo (7/5/2016)

---

So you have two SQL instances with at least one Availability Group on there? Can...

Thanks a lot folks. Will heck out what Upgrade Advisor can tell me. And definitely we are testing but wanted some experience too since I believe some folk out there...

I disabled the antivirus temporarily and was able to install SSMS 2016

It turns out the installations was being blocked by McAfee antivirus. 😉