1) Yes, 2) Yes, 3) I have built reports with 2008 tools and deployed to 2005 RS, and 4) Yes. 😀

The screen shot you show is fairly normal. You should be able to click next and walk through the installation. Be sure to use the Configuration Wizard once the install...

madhu.arda (11/7/2008)

---

The prerequisite check failed for a default report server installation:First time install, the SQL instance is either not selected or is not a local install.

Was that the error...

Best thing to do would be to get the reporting services installed and then walk through the "Reporting Services Configuration Wizard" under start > programs > ..SQL Server 2005 >...

The restore of msdb will take care of jobs and I believe you alerts as sysalerts resides there.

The procedure that Tracey mentioned will allow you to script out the...

The standard rule of thumb is not to use select * in a view for the very reason that you would have to refresh the view with every change of...

Thanks and I did think about trying that. Have you seen this before? Very curious.

Are you referring to Activity Monitor in SSMS in 2008? If so, then you will need to run a trace to collect the different queries that it runs and probably...

Assuming this is reporting services.... If so, then you need to look at the details of the report (view details when looking at the available reports). You should then be...

I would actually use the SQL Server 2005 Books On Line resource first and then search out questions from there.

I struggling a bit with why you would use the same server that you have as a publisher and possibly a distributor unless you have another instance on the same...

Just stumbled on this post but wondering where you see these faults? Curious.

This link - https://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=377594&SiteID=1 - should help in troubleshooting this. There are a couple of blog entries as well regarding the warnings you are seeing.

This query which is part of the procedure you are referencing will return all the backups. So, find this portion of the code and look at the query. Start looking...

I would be a bit concerned about this configuration even...