Via the gui.  The interface did not permit any restore files locations except those on the C drive. 

The only thing I can think of is maybe the SQL2000 backup...

That worked.  Thanks.

This is very helpful.  Thank you.

I couldn't find this in books online.

Thanks a lot!  Problem solved.

Converting the char values to literals solved the problem.

This is not my code, so I don't know why datetime was used.

Thanks for your help.

answers:

1.  What is the error?  Incorrect syntax near 'CHAR'

2.  Why are you trying to convert 2005-07-11 00:00:00 to DateTime WHEN you...

Tim S.  Your code did the job.  Thanks.

Sorry we don't speak the same language.

You can run xp_sendmail from a server connected to a sql database on another server.  You need rights to EXECUTE commands from the master...

<sigh>

Server b only has the SQL server client tools installed...

we are running xp_sendmail on that server.  We registered Server a's database

on server b.  Both have sp3.

The sql server account has...

Tried this.  Still same error number 18025.  Micro$oft has some knowledge base articles about this, but not for my specific problem.

I did mention that.  We could place the views on our network.  Another solution is to link our SQL tables to an Access application and let them play in that...

Yes.  A few spoiled end-users have seen the Query display available in EM.  It is similar to Microsoft Access.  I wish this display was bundled in QA.

This error was caused by an accidental space at the end of the database name.  When I backed up the database and restored it without the space, the problem was solved. ...

Unfortunately, you are correct.  After I installed the service pack, the problem went away.   Our software does not support that version of SQL2000, but since I don't wish to downgrade...

I ran Graeme's routine and followed it by a shrinkfile command on the data file.  It worked!  The routine freed up about 10G.  Thanks for all the great advice!