I was trying to use this on a SQL 2019 server but when the report is sent it is completely blank.  Tried setting the Compatibility to SQL 2017 but still...

Have engaged MS support and they have not yet been able to determine what exactly is wrong with the Reporting Services on this server.  Still working with them.

Is this the log you are looking for?

<Header>
<Product>Microsoft SQL Server Reporting Services Version 2009.0100.6000.034 ((KJ_SP3).140819-1214 )</Product>
<Locale>English (United States)</Locale>
<TimeZone>Eastern Standard Time</TimeZone>
<Path>D:\Program Files\Microsoft SQL...

Love the script. I was also getting a blank report. What I discovered was that when adding the values for best_latency, worst_latency and average_latency, it did not have...

This is most definitely a sp2 issue.  I have reports I have done recently and they work fine on sp1 but show the black background on sp2.  It seems like...

I have my SQL Server registrations disappear every time I change my password.  Is there a way to prevent this?

Is restoring them from a registry copy the best way to...

We are working with this issue right now and have 2 important questions about using the Basic Authentication for connection to the SQL Server.  We do not have AD and...

When just needing a quick fix I have created a identity field, deleted the duplicate record and then deleted the identity field.

Anthony,

I never could get the first script to send an email.  I have used scripts similar to this which worked.  When I try to execute the stored procedure directly from...

Craig,

I have the following procedure in the master database.  Since this is in master I can grant the user permission to execute this procedure without giving them permission to execute...

Also when you do a TRUNCATE you don't lose the user permissions you have set up on the table.

gayle nb,

Just wondered what you used it for.  Has your personal experience found it to be easy to use?  When you said 'depending on how you set up the database...

Dave,

When I execute your stored procedure in Query Analyzer I don't get any value returned.

Sue

Thanks aureolin!  That did the trick.

Sue

Aureolin,

I got your script to work but could not get it to work with the echo statements.  I guess a message box was waiting for a response but I could...