Thanks guys, the problem has been resolved. We made two changes prior to the last server reboot:

1.Changed the service timeout from 30000 to 120000 (http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2776350&SiteID=1)

2.We found a DCOM security...

Hi Jack,

The RS services are on the same machine as the SQL services. IIS is running fine.

Rgds, Scott

Hi Andy,

Thanks for the article - a great summary.

I have been working with a number of these options recently. A particularly useful feature is being able to set the background...

I have also not had time to benchmark performance, but here is another technique that gives the illusion of randomisation:

ORDER

BY SUBSTRING

I don't think too much can compete with test cricket.  The game has a very long history and the structure of the entire complex game is a statistician's dream!  Consider...

Hi HABIB - thanks for the response.

Some more info on the problem:

SQL Server Agent is running on the domain administrator account.  This account has been...

Great article - but I can't find part 2...

Scott

Great article - what about some suggestions for performing case insensitive searches on case sensitive databases?  Is the best option here to just use UPPER?

Regards,

Scott

Very nice procedure - but the example data you provide doesn't match the graphs you display as output - or am I missing something?

I have also made extensive use of DMO for database comparison and synchronisation. Performance were not a big issue for me as these processes where only for administrative use....

Yes, I am using SQLDMODep_FullHierarchy in the EnumDependencies - but in the background this makes a call to sp_MSdependancies:

exec sp_MSdependencies null, null, 70141

In turn this procedure uses the sysdepends table...