Do you mean that you want to find out how many SQL Servers and what versions are installed in your environment

In Sharepoint mode, you can have your SSRS reports deployed to sharepoint.

Have you followed the correct steps on how to create Parent-Child packages.

http://msdn.microsoft.com/en-us/library/ms345179.aspx

Why are you casting Float to Varchar. Why dont you set @param as varchar initially.

Create a roll-over trace files and then run the DETA on each of them seperately.

ROUND() function is another way you can try.

The simplest method to refresh is to take a backup and restore the latest production copy

With RESTORE DATABASE WITH MOVE, you can provide new locations for your data files.

You will need the full 1.6TB of space to restore your database. However you can create mutiple filegroups and files to create secondary data files on to different disks. I...

You might want to take a log backup before and after the process.

If you block the port 1433, 1434, you need to make the change in your application connection string to add a new port otherwise you won't be able to connect...

Do you have any other SSMS installed I mean of 2005. Test with SSMS 2005 if you are able to update the jobs then we will know if this issue...

Just check if the job is pointing to the correct database.

You should have 64K stripe size for SQL Server. You may also test with the stripe size of 256K because it can help increase the performance of the read-aheads.

Run sp_who to check if any connections are made to SQL Server