Problem with Report 97 after upgrading to SP3
We found a problem with SP3 last week and was planning on contacting Premier support about it once the Furlough was over. Not allowed to contact them at the moment. DOH and I spent the better part of 4 hours trying to resolve this problem. But it looks like we where not the only ones to have this issue. I didn't see this problem in the lab. My guess is because of the size of the DB.
Here is the legist of the problem. Once upgrading to SP3 Report number 97 no longer works due to a change in the Add Remove Programs View.
Looks like others have had this issue and a temp solution has been posted.
MyITForum post on problem:
http://www.myitforum.com/forums/post_SP3_issue-_sql_process_100%_/_slow_reporting/m_157335/tm.htm
Blog post on workaround:
http://blogs.technet.com/smsandmom/archive/2007/06/28/sms-2003-sp3-add-remove-programs-reports-may-cause-a-cpu-spike-and-or-sql-timeout.aspx
If you work for the Commonwealth Of Pennsylvania I will include a working MOF file for the replacement report in the July Newsletter.