We have seen the same tran backup issue with using 'All User databases' since applying SP2..then SP2a.     I seems that before SP2 'All User'...

Wonderful!  In meeting just yesterday expressing the same type requirements for a DR  tracking application. I also have been using RS and now SSRS since it came out.  We are very interested...

8 Servers/ 5 are production with 11 instances not counting development VM's.  About to add 1 more server and 3 more instances for 2005 conversions.  Also support 6 instances of Reporting...

Great overview.  What I find the most confusing with SSIS is the new package security, encryption options, storage options, migration of packages, etc.  Any good resources on that?

Thanks,

ABates

But if you want SQL Agent job and error notifications you have to manually script the jobs and change them to use the smtp dll.  We use both because smtp...

We use the IBM DB2 UDB iSeries OLEDB provider (Client Access is the name of the product I think).  Fortunantly MS included a DB2 driver in 2005.

AB