Right, so if you go the properties of the Execute Package Task, it will tell you what instance and the package name of the package the Execute Package Task is...

An Execute Package Task runs a separate package from the one that you are currently in. Since it does not have arrows, it is most likely running in a separate...

If the server you want to restore to is connected to the network, then you can copy over just the backup file(s) you want and restore to the new server,...

I agree with Gail. There is no way to troubleshoot this without sufficient information on your environment and the queries you are troubleshooting. Please post eveything you can in order...

You can also check the client network utility on one of your clients and ensure that it is setup to conenct properly. I believe there is an area where you...

I think I was unclear before. I apologize. The tools install you were trying to run is an msp file. It cannot be applied by itself, it needs to reference...

Install from the original media, then run SP3 again to upgrade just those components.

There could be a lot of reasons for this. Are there any errors in the SQL log or the event logs? Any networking errors or outages at that time? If...

It sounds like you are either writing to tempdb in the stored procedure, or the underlying views you are accessing are using tempdb in some way. Try running Profiler and...

It may be easier to restore from a backup.

Not sure if this is your issue, but have you checked your disk subsystem? Are there any errors reported? High disk I/O from another process or job? Also, if your...

Have you tested it? If you run the query statement that is being assigned to @query in management studio and have the output written to a file that would probably...

Will this not work?

SELECT RTRIM(COMMENTS) FROM <table_name>

I am not positive, since we have Windows Firewall disabled on our clients at work and depend on a hardware firewall for traffic in and out of our organization. I...

Is the Windows Firewall turned on? I wonder if it is blocking port 1433 from connecting.