Ima LMAO at the responses here.. Thanks!

SQLRNNR (7/1/2014)

---

Zubius (7/1/2014)

---

SQLRNNR (7/1/2014)

---

TheSQLGuru (7/1/2014)

---

SQLRNNR (6/30/2014)

---

I would recommend the defrag script by Michelle Ufford way before any others offered on the internet based on experience and client experience with the...

SQLRNNR (7/1/2014)

---

TheSQLGuru (7/1/2014)

---

I would...

Thank You both for the prompt replies. I was struggling with this for some time. I'll run a few tests during our next maintenance window and post back If...

Here are a couple links that should help;

http://msdn.microsoft.com/en-us/library/ff877954.aspx

http://www.mssqltips.com/sqlservertip/2573/monitor-sql-server-alwayson-availability-groups/

Along with the info provided in those, I've also set up jobs to notify...

Thanks Perry. I'm actually executing the stored proc with INSENSITIVE cursor now...

Richard Moore-400646 (2/15/2012)

---

This issue is most liley related to the cursor against sysdatabases. Change the cursor to a static cursor and it should resolve the problem.(CURSOR STATIC FOR SELECT)....

Thanks for all the suggestions.. I'll make a couple modifications, rerun the job and post the results later.