If that's the case start installing sql server from the server consol instead of using terminal service to connect to it.  Make sure to reboot your server before you start.

mom

Just a though, I have done a couple of sql uninstall, save files and then reinstall because we had to remove enterprise edition, it might work the same for you...

1st. Rule, the login account need to be domain account and that account belong to  administrators group on that particular server.

2nd.  Now that you have already install sql 7, let's uninstall...

I am not sure what to do beside looking for the latest backup file.

mom

I think you should log in as SQLAdmin to do your maintenance to avoid the conflict.  Your personal login should has access to the sqladmin mail box, but sqladmin should...

1. Make sure the new service account is part of the windows user group

2. give the new service account to read/execute not full control on your c:\

3. give the new...

How many sql server do you have?  If you have only 1 sql server then I suggest that you don't use sql-mail because you can't set up a process to...

to see what is schedule and the file to be run type at the command prompt: 

at \\servername

I would recommend that you look at the file it try to run and see...

I wonder if you have access to those databases?  If you do you could write a script to connect to each dr.'s office and find just which job fail and...

http://support.microsoft.com/default.aspx?scid=kb;en-us;821277

If you apply the patch in the link above, it will bring your server version to 8.00.818

mom

I think you should ask the sysadmin (for sql server) to be solely responsible for your database backup and recovery.  If there are just regular sysadmin and there is none for...

go

EXEC sp_change_users_login 'Update_One', 'Mary', 'NewMary'

This command above will fix your problem if you restore your database to different server, you still need to make sure the login exist on the...

Restore master will gives you all logins, restore users database will give you all database, users and rights, restore msdb will give you all your backup tasks and other stuff. ...

How about try to stop sql-mail and then re-start it.

xp_stopmail

xp_startmail

Test your xp_sendmail with attachment again.  Good luck.

mom

I don't remember.  Sorry it's been so long since I test this out.  You can try it yourself.

mom