Just try this and let me know isql -E -S.

Also you can use profiler or server side tracing to monitor the database usage.

MERGE REPLICATION can be used but since you say that auto id is being used in MSGP you have to read replication twice before that can be implemented idenity columns...

There is shrinkdatabase task in maintenance plan can't that be used to shrink th log file.?

If you want to have a tool then try using data compare tool to sync data between the resources.

Yes when a table is dropped the depending objects like constraints, indexes are also dropped.

You can choose a better option but remember to move the logins. jobs, etc they are important too.

Move to latest Service pack for SQL Server 2005.

Can you post the errors that has been reflected in error log of sql server.

If you use .net then you can create a datasource and then say which script is to be executed and then deploy the report.

Might be adding the connection setting options to the trigger and enabling them would solve the issue.

SSIS packages can be scheduled as a job step in SQL Agent you have a option for that there.

THERE IS  a script available in microsoft site named sp_help_revlogin that can be used to transfer the logins from 2000 to 2005 servers.

DBA does not require Admin privileges on Windows but most companies give that so that he can perform his tasks with ease without needing them to depend on the Windows...

Thanks learnt that this can be done using undocumented DBCC. The given below is alist of few

http://www.mssqlcity.com/Articles/Undoc/SQL2000UndocDBCC.htm#part_2_12