You can get this information from the exectionlog table in the ReportServer database. There may be some 3rd party that has written some reports using this, but I don't...

I'm not sure I understand what you are asking. Do you want to retrieve the MAX(StIDPK) and then increment it before doing an insert? So if you have...

The only thing I have found is that the Subscriptions table has a LastStatus column, that you can check for '%fail%'

You can build your SQL String into a variable and use the variable instead of doing the concatentation in OPENQUERY.

I don't think you are gaining anything by using...

Here's a link to a blog post by Lynn Pettis that I refer to whenever I need a date routine.

How would you suggest MS implement "dynamic" creation of columns within a dataset? At some point the engine has to know that FirstName goes in column1 if it is...

Can you explain why you are using an Instead Of Trigger? I have seen very few instances where they are necessary. I'm not saying it's not necessary in...

Can you post the code you use to set the EDATE parameter?

If you are using an expression it does not seem to work. You can tie the EDATE parameter...

sqlquery (8/25/2009)

---

I am replaying profiler trace on other server and have couple of issues

1) I am not able to map which event created error as it shows error in

replay...

Sounds like you may want to look into creating a CLR function for this. You could do it in a T-SQL function but probably wouldn't scale as well as...

Have you looked at Operations Manager? That will monitor your logs and send out alerts.

You can change the email account using the Reporting Services Configuration Manager.

You can check the status in the subscriptions table in the reportserver database. It has the a column...

I sent the link out via Twitter as well to get some more exposure.

Hmmm, interesting question. Do you need to do the compare in the main report or the sub report? If you can do the compare in the sub report...

SSRS stores the names of the columns as part of the report definition (rdl file), that's the only way it can know what to display where in the report itself....