Make sure you install DTS addins to edit/maintain the dts packages in 2005.

http://www.microsoft.com/downloads/details.aspx?familyid=d09c1d60-a13c-4479-9b91-9e8b9d835cdc&displaylang=en

Microsoft SQL Server 2000 DTS Designer Components

The Microsoft SQL Server 2000 Data Transformation Services (DTS) package designer...

Then... Create SSIS package and choose FAST LOAD option ....

I don't know they are calling option as FAST LOAD or something else in 2005.

As I mentioned before I don't think there is any way within the sql...

If you find the way, please share with the forum..

Aways use exec to execute procedures and qualify the names too..

exec master.dbo.sp_help

Doing the local backup and copy the bak file to nework location is good idea but when you don't have the space, you have to use network backup....

If there is...

Read the following following and scripts... modify the script to write the fragemtation info to table before and after reindex and reindex execution times too...

http://www.mssqlcity.com/Articles/Adm/index_fragmentation.htm

You may or may not...

Add the new .ndf file and cap (Restrict the growth) the .mdf file growth.

Yes your right...I totally forgot

Creating the maintenace plan is not that hard... you can do from SSMS also without opening ssis project..

Use MP...

No more QA and EM in 2005...

New tools called SQL SERVER MANAGERMENT STUDIO (SSMS)

There are plenty of new feature and deprecations...

http://groups.google.com/group/microsoft.public.sqlserver.programming/browse_thread/thread/40a13a024a5fceeb/55f27470db401692?lnk=st&q=difference+between+sql+server+2000+and+sql+server+2005&rnum=1&hl=en#55f27470db401692

Did you enable "Ad Hoc Remove Queries" option is Surface Area Configuration?

If not enable it before running the query...

Check sysdbmaintplan_databases and sysdbmaintplans table and view..

You may need to write a query join the tables and views to get all info you need...

Always it is better to do side by side upgrade for CLUSTER and REPLICATED servers instead of inplace...

Did you use any switches while running CHKDSK?

Is your disk are SAN attached?

We use HP...

SAN backups will not showup in restore tab...

SAN backups are done by freezing the db and copying the ldf and mdf files not like backup files...

I don't see...

Then else part is fine but as I mentioned your current execution of the job will not be effected...