Are we going to see any major changes in SQL Security as what we saw in SQL 2005.

If you are using Maintenance Plans then there is a option to remove unused space before backups.

Better backup the database to disk and then move the backup file to TAPE. SO that you can restore it on need. But plan this as each file will take...

If the file exsists then check for the permissions for the users trying to use the DTS package.

If you want to get the scripts to change the structures then go for tools like SchemaCompare by Red-Gate or Quest or SQLDelta they have better tools to do these...

You have to use the delete old files option available with the maintenance plan.

Could yo post the table details of CaseNum it lloks there is a computed column in the table or view.

If defragmentation is heavy then DBCC shrinkfile will be very very slow. Check for defragementation in the database.

You can choose to install management tools when you install the server. There is a option available.

Just to add one imp note MS has fixed almost 450+ bugs in SQL 2005 SP1 and almost 300+ in SP2.

Other questions are there any open transaction in the server.

Do you have any delete file jobs configured in the plan other any othe tasks that get invoked check them they will create a subplan if necessary.

Hey i dint realise that i was misspelling. sorry for that Brian(Brain).

You would be needed to give some permissions to some tables nad stored procedures in msdb database.

I hope with SQL 2000 you can't get this information. But the same can be obtained with SQL 2005 using DMV's.