Put [] around the RNum.  You need to list the columns instead of having * also.  This is bad for performance and lazy coding.   Also, as someone mentioned earlier, you...

And did you run detach to detach it from the database, or just shut the server off and move it?

Just contact your hosting company.  They're generally very cooperative.  There's a lot of competition out there.  If they're not cooperative, remind them of this fact.  You are their customer.

To add a little to MrSQL's list:

(A) Maintenance!    Not only will everything take longer, but everything will be more critical.  You need to...

The stored procedure will run faster as long as the cached plan remains cached.  At the point a recompile must occur, it should be about even.  The BIG exception to...

Exchange 2003 doesn't even support MAPI unless you specifically enable it does it??????

Did you track the application name?  Also, did you look at the ClientProcessID and see if there was a pattern there. 

You probably won't be able to without contacting the web hosting company.  Generally, they will make a backup nightly though.  They will need to make you a Backup Administrator to...

There is no reason to not be on SP3a.  You need to upgrade immediately.  Until you do, your SQL Servers are a very high risk.  It might also fix your...

???  Give Mypc access to SQL Server? 

Import the flat file to one table with one column.  Write a stored procedure to insert the data| lines into seperate tables as the next SQLTask.  Then move the data...

Are you backing up to tape or to a local drive?  This is generally a hardware error, as I'm sure you've guessed.  Have you done a read/write stress diagnostic on...

A lot of us minimize our use of Enterprise Manager because it has a LOT of flaky things in it. Do you have the latest service pack for SQL Server...

How did you get this .mdf file you're trying to attach? 

I'd do the backup and restore one more time before calling PSS.  If it doesn't work:

1.  Run a hardware diagnostic on your server.

2.  Contact the hardware vendor.

Assuming your hardware is...