I may have figured out the difference between the two.

In Control panel I see Microsoft OLE DB Driver 19 for SQL Server with a Version of 19.3.1.0.

This appears to be...

Thank you.  I will plan to update the OS first.

• This reply was modified 1 year, 8 months ago by  MK Morris.

Thanks Sue.  Your help is much appreciated.

In this case the command was -

exec [ReportServer].dbo.AddEvent @EventType='ReportExecutionUpdateSchedule', @EventData='c3f3ba1a-ab7e-4613-9016-7f397538419c'

That helps for the ones that exist in the Reporting Services tables (ReportSchedule, etc.).  However, since this one (and 5 others) don't exist in the ReportSchedule table it won't help.

Well I learned something new today.  I was able to trace one of the SQL Agent jobs to an old report that was setup with the option "Render this report...

Thanks Sue!

Forgive me for replying to such an old post.  I came across it when searching for information about something I observed. 

DATABASEPROPERTYEX(name, 'Collation') returns NULL  for a database...

Actually, the problem is a little different from what I original posted.  The following is more accurate and includes a solution using a loop.  I wanted to see if there...

Also, if it matters, the percent complete, shortages, etc. will change daily. I'm not sure how you handle that with Analysis Services.

Here is representation of the current process -...

Thanks for the reply. I went ahead and moved the database over.

It wasn't that big of a chore and everything seems to be working great.

Kevin

Hi Charles,

This looks like a nice script. Is there a reason it does not add the server roles for Windows logins?

2nd Edit: Now that I look at it...