Thank you for the feedback.

I'm sure you've heard the saying "you can't manage what you can't measure." A lot of times in the technical world, your manager...

Gail,

Do you have a general process you go through...

Is your report server configured to send email?

http://msdn.microsoft.com/en-us/library/ms160334(SQL.90).aspx

If it is you will need to create a subscription for the report. If you have publisher rights on the report, you...

Scott Solice (5/5/2009)

---

This is great. I'm assuming the time elements in the ExecutionLog table are in ms, is that correct? And, Where can I go to for a full explanation...

There are others but none as good at SQLServerCentral!

Here's the reporting services board http://www.sqlservercentral.com/Forums/Forum150-1.aspx?Update=1

Some other reporting links I use are:

http://www.sqlpass.org/LearningCenter/Top10Lists.aspx#learnrs

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

http://searchsqlserver.techtarget.com/generic/0,295582,sid87_gci1172656,00.html#">

http://www.sqlpass.org/LearningCenter/Top10Lists.aspx#learnrs

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

http://searchsqlserver.techtarget.com/generic/0,295582,sid87_gci1172656,00.html#

However, the...

It could be a lot of things. Running report services on xp pro is a bit unusual. Your production server is probably just over utilized for this query...

Very limited reporting functionality is in workgroup edition: http://www.microsoft.com/sqlserver/2005/en/us/reporting-services-features.aspx

This article is intended for express edition, but may be helpful for workgroup as well... http://www.sqlservercentral.com/redirect/articles/66737/

Really no great solution, but this will work....

http://joseph.randomnetworks.com/archives/2006/05/22/sql-server-equivalent-to-mysql-and-postgresql-limit-clause/

Sounds like the manager doesn't know what he/she wants. I would use this as an opportunity to control your own destiny. You decide what numbers to measure yourself...

That is strange. I can run 350 records in under 1 second with the same query. What kind of date range are you looking at? You may have...

Those are probably scheduled subscriptions. I happen to include them in my reports, but it's up to you. I like to provide a total number of reports ran...

this one runs quicker for me...displays only user tables

SELECT

a.name, object_name (i.id) TableName, rows as RowCnt

FROM sysindexes i INNER JOIN sysobjects o ON (o.id = i.id AND o.xType = 'U')

inner...

Good question....if you have a helpdesk system, this is a great place to start. Open tickets, closed tickets in a certain time period, average days to close a ticket....

I...

this should get you started:

select ExecutionLog.UserName,Catalog.Name,Catalog.Path,ExecutionLog.TimeEnd,

ExecutionLog.Parameters

from Catalog inner join ExecutionLog on

Catalog.ItemID = ReportID

where

ExecutionLog.TimeEnd between @begdate and @enddate

Order by ExecutionLog.TimeEnd

This is in the reportserver database

Glad to see the Reporting Services articles. This is a good one. Never would've thought of creating the formatting info back in the sproc...

Also nice use of...