http://www.quest.com/

I think you need a good recovery plan, lost of one week productivity is way too much and unacceptable to me.

How large is your database?

Since you are able to run package using dtsrun outside SQL Server, It looks like you need to increase the memory reservation in SQL Server process with paramemter -g for...

I don't think multiple instances will help. Instaed, I think it may become even worst since the workloads remain same.

DBCC Shrinkfile can shrink the log file to any size you want.

Is it a dedicated SQL Server or other applications also run in the same server?

You have to figure which processes are taking away your resources (CPUs, Memory etc), It may...

There is no way for SQL Server 7.0 to use the memory above 4GB.

Try to login it with OSQL.exe and run sp_helpdb to find out the database name.

You can get it from EM if you have other SQL Server installations.

Run sp_who2 to find...

What is your database recovery mode currently?

If it is in FULL recovery mode, you have to setup a job to backup the transaction regularly.

You can also change it to...

Did you enable /3GB at same time with "AWE"? Are all instance run i same physical server or in different nodes?

When you issued statment to query 32 bit linked server from 64 bits server, the query is looking for stored procedure sp_tables_info_rowset_64 in 32 bit server and it doesn't exist.

What I...

I have no issue to link my 64 bits server to 32 bits one, try to link to another 32 bits server to see you still have same errors.

In addition to add more memory, you may also consider

1. How do you configure the disk system, what type RAID do you have?

2. How do you allocate the database and...

Try use Profiler to trace which stored procedure is not found.

Long PAGEIOLATCH waittype mostly indicates I/O subsystem bottleneck, Check whether you have high disk queue length from perfmon.

Yes you can with some tricks but you can only use global temp table. Create the the temp table from QA first, then create "execute SQL task" that create a temp table...