We're in exactly the same situation as Bob Barrows, even down to the one app that's keeping a SQL2000 server going!

We have the added delay that any new software has...

Check out Michael Davis's Report Server Diagnostic Report Pack here on SSC -- it's a series of SSRS 2005 reports that lists reports, last accessed, permissions, etc. Not sure how...

Sounds like a school homework question to me.

Only the rdl files and data sources are deployed to the report server so your sln and project files are never there to recover. Your normal fileshare backups will take...

This tickled something in the back of my head, so I went hunting--found this article. It's pretty old (2004) but it says that, at the time, more than 70% of...

You could have a look at where the original data is coming from - if it's via an SSIS package then put a splitting function into that and create extra...

Go to your control panel, add/remove programs and repair/reinstall your MSXML 4 or 6 (the latest one you have which depends on which SQL Server version you have) as we...

Notepad++ as a text editor as it will display sql, xml, html and other things in a nice readable way and will handle those large csv files that need tweaking...

The third Friday of every month is "Patch Friday" from 4p.m. through to Saturday when windows patches, any sql CU and any apps releases that need full business downtime all...

I'd be some sort of multi purpose off road vehicle!

We did this comparision when we were searching for a software suite. We wanted a multi purpose 4 wheel drive MPV...

Been there with over a hundred tansformations. It is now a control package that calls eight packages which divide the tables fairly evenly between them in alphabetical blocks, so I...

+1 for RSScripter http://www.sqldbatips.com/showarticle.asp?ID=62

I've just moved a huge server full of reports including datasources and subscriptions from sql 2005 to sql 2008 using it. It's free and easy enough -...

Yes, two servers. One is gradually having things rewritten and moved to 2008 whilst the other has had everything moved to 2005 ages ago bar one last project waiting for...

My plan for when I get paid off through redundancy or voluntary leavers is to take time out to get the building works at home finished, then the camper van...

Reports written using BIDS 2005 can be run on a 2008 server. I can't remember if I deployed the report from BIDS or pulled it in from the report manager...