Not yet, will do and let you know how I make out. Thanks Steve!

David

Yes, this is to get SQL Mail working again and both the Server and the Agent are working fine except with mail. I can still mail from the client directly,...

The sp_spaceused system stored proc will bring back everything you want and the sp_MSforeachtable will let you get all the tables in the current db at once. I'm sure that...

Try using sp_attach_single_file_db and see how that goes. This will eliminate the transaction log from the attach and "should" work.

Good luck.

David

Should have stuck with my gut feeling at first. Thanks for letting us know what the problem was.

David

DUH David! Sorry I didn't catch this before but your path to the file has spaces in it and that won't fly. You will have to put quotes around the...

Is the wilda account listed a valid email account. If this account is not on your domain, then you should specify the smtp address such as your.name@yourdomain.com

Other than that...

You have to use the "with move" option. However, if you can detach as Oleg has offered, then the files you would look for would be the .MDF and .LDF...

Backup from current location and restore to new location.

Should be all three options in three posts.

David

Are you sure that another table is not referencing this table as a foreign key and by truncating it you would be causing a constraint there?

Right click on the...

Unfortunately that's not possible. Ultimately your best bet from what you have described is to restore to another "mock" database and copy tables back over.

David

I just had to search this out so that I could work through this issue. Thanks for doing much of the leg work for me.

OBTW - Great Article /...

Sounds like permissions or path may be inaccurate. If you post the code that would be helpful. Thanks.

David

Assuming that your global variable is formatted to reflect the proper email address you could use xp_sendmail and then set the @recipients variable in that procedure to equal your global...

I have found that task to be unreliable. It gets more reliable if you go through the options (options button on transfer tab)and deselect the "transfer database users and database...