David, this was an interesting read. Thanks for your post. We have used the script here:

http://blogs.msdn.com/b/ikovalenko/archive/2006/12/03/alter-database-alter-collation-forced.aspx

when changing database collations. Hopefully you can also put it to good use when the...

Would like to see compression in Standard edition.

Not sure about the x86 vs. x64 driver issue, I'll do some testing today and see if I can come up with anything.

Regarding the query that was used against the...

Just wondering if you've verified the objects in the messages below exist in msdb?

2010-06-04 05:48:01 - ! [298] SQLServer Error: 208, Invalid object name 'sys.configurations'. [SQLSTATE 42S02] (DisableAgentXPs)

2010-06-04 05:48:01 -...

An even better solution would be to selectively reorganize/rebuild indexes based on fragmentation levels. This way you're not incurring unnecessary overhead of defragmenting indexes that aren't fragmented enough to impact...

Finally solved, following the instructions here:

http://blog.iautomate.ca/2009/08/no-connection-could-be-made-because-the-target-machine-actively-refused-it/

Never had to touch one of the rsreportserver.config file until now...

Even further confused...tried editing report's properties via Report Manager, then noticed the below entry in the Report Server service log. We're not using SSL, so I'm not sure why a...

This problem could also crop up when attempting to install the SQL Server 2005 workstation components (management studio, business intelligence development studio, etc.) on Windows XP SP3. I ran into...