Hi ! One of my guys were fixing a report, and after running the report the web reports stoped working. We get this error --- Server object error 'ASP 0177 : 8007000e' Server.CreateObject Failed /SMSReporting_SWE/ReportsNav.asp, line 1046 8007000e --- The line 1046 is Set myReporting = Server.CreateObject("SMSRPHost.SMSReporting") This is the report we were running. --- declare @Total int declare @Accepted int select @Total=count(*), @Accepted=sum(case LastState when 0 then 0 else 1 end) from v_ClientAdvertisementStatus s inner join v_AdvertisementInfo i on s.AdvertisementID=i.AdvertisementID where s.AdvertisementID in ('SWE20103', 'SWE20105', 'SWE20106', 'SWE20107', 'SWE20108', 'SWE2010C', 'SWE2010D', 'SWE2010E', 'SWE2010F', 'SWE20110', 'SWE20111', 'SWE20112', 'SWE20113') select s.LastAcceptanceStateName as C013, count(*) as C015, ROUND(100.0*count(*)/@Total,1) as C016, s.AdvertisementID, i.AdvertisementName from v_ClientAdvertisementStatus s inner join v_AdvertisementInfo i on s.AdvertisementID=i.AdvertisementID where s.AdvertisementID in ('SWE20103', 'SWE20105', 'SWE20106', 'SWE20107', 'SWE20108', 'SWE2010C', 'SWE2010D', 'SWE2010E', 'SWE2010F', 'SWE20110', 'SWE20111', 'SWE20112', 'SWE20113') group by s.LastAcceptanceStateName, s.AdvertisementID, i.AdvertisementName DECLARE @Count int DECLARE @aid varchar(10) DECLARE cur CURSOR FOR select distinct AdvertisementID from v_AdvertisementInfo where AdvertisementID in ('SWE20103', 'SWE20105', 'SWE20106', 'SWE20107', 'SWE20108', 'SWE2010C', 'SWE2010D', 'SWE2010E', 'SWE2010F', 'SWE20110', 'SWE20111', 'SWE20112', 'SWE20113', 'SWE20091') OPEN cur FETCH NEXT FROM cur INTO @aid WHILE @aid <> 'SWE20091' BEGIN select s.LastStateName as C017, count(*) as C015, ROUND(100.0*count(*)/@Accepted,1) as C016, s.AdvertisementID, i.AdvertisementName from v_ClientAdvertisementStatus s inner join v_AdvertisementInfo i on s.AdvertisementID=i.AdvertisementID where s.AdvertisementID=@aid and s.LastState!=0 group by s.LastStateName, s.AdvertisementID, i.AdvertisementName END CLOSE cur DEALLOCATE cur ---

Will it run in SQL Management Studio?John Marcum | http://www.TrueSec.com/en/Training.htm | http://myitforum.com/cs2/blogs/jmarcum

Hi ! I haven't tested the Query in SQL Management Studio. The server started to show an increasingly amount of used memory in the "PF Usage" under Performance in taskmanager. It differed more then 1gig between "PF Usage" ang the accumulated "Mem Usage" by processes. So I figured memory issue. After restart of the server the reports were working fine. // Kristian