It would be possible to do this as a set based operations if you built an sp on the fly and then executed it.

Another way to do this would be through SSIS to populate the data, have a look at this method.

http://www.sanssql.com/2011/08/looping-through-sql-servers-using-ssis.html

Yep, it makes an A S S out of U but fortunately this time not ME 😛

Do you see what i did there 😉 A SS-U-ME

Hi b3yond,

This script was posted on Jan 14th 2008... 7 months before SQL Server 2008 was released and therefore before those data types existed.

OS is windows server 2008 sp2

64 bit

Total Memory 32GB

Allocated 12GB

SQL Build is 10.50.1765

Can you connect to the reporting services instance from management studio?

For exmaple the path on my local machine is C:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting Services\LogFiles

Have you looked at the IIS log or the reporting services log?

Have you configured it yet or have you just installed it.

If not you will need to use SSRS configurator. Within this it will let you provision the different URLs.

I'll take that as a no then...

If you are very lucky the last full backup may be hidden somewhere in the filesystem (if there ever was one).

Try running the the below query. Its a longshot but...

This pretty much worked for me though i had to reset the registry entry again before stopping and starting SQL in cluadmin.exe.

Are you rebuilding all indexes regardless or are you doing it based on fragmentation?

Create the table structure

select sj.name,sjh.* into [CentralHistoryTable] from msdb..sysjobs sj

inner join msdb..sysjobhistory sjh on sj.job_id=sjh.job_id

where 1=0

For each server you want to pull data from (Though this will initially import all...