All my databases are SQL_Latin1_General_CP1_CI_AS which as far as I know was the SQL Server 2000 default.

I am pretty sure that when I installed SQL Server 2005 that I took the defaults. The ReportServer databases have a collation of Latin1_General_CI_AS_KS_WS.

You fix still errored off so what I did was to add and [name] != 'ReportServer' and [name] != 'ReportServerTempDB' to the second union's query.

That seems to have gotten around the issue.

Anyone know if the ReportServer settings are normal?

-- Mark D Powell --