Jeff,

Have you tried using the sp_attach_single_file_db method. That way you can forget about the log that is giving you fits for now. The attach will recreate the log in the...

You may have already assumed this but it needs to be a server of the same version.

David

No, that is valid syntax and it should work fine. Sounds to me like the machine you are trying to write to either doesn't like the permissions that SQL is...

Andy,

I haven't tested this yet but I will be. I had thought that the "two log file, missing one" scenario was one of those issues that you just had to...

The following will work for you;

if exists

(

select name from tempdb..sysobjects where name like '#YourTable%'

)

drop table #YourTable

Hope this helps.

David

I would try a restore of the MTSDE database from a backup off the other server. Sounds like master is not referenced right to that db and the only way...

Just to make this nice and clean the solution they provided for Neil worked for me as well. See the post that is referenced in my previous post for more...

Well, it appears that the fix they gave to Neil is going to work for me as well. Although, not to give bad press, it seems like they were hesitant...

Working on a similar issue as well. Hopefully we can arrive at the same solution at the same time as this is getting old. See the following post;

http://www.sqlservercentral.com/forum/link.asp?TOPIC_ID=2348

Nice...

Cancel that. Had to try it once more with xp_sendmail and it failed. Thanks again. I may burn an MS call on this one. Thanks.

David

I attach the results of a sum query for customer review. What is the article num?

Not sure that I will need it because after running the Office SR1 update...

No helpers, no changes, and no on the MTS usage.

The only thing that is even a remote possibility is a network outage over the weekend affecting that server but,...

Jody - I probably should have made this clear before and looking back at the posts, it doesn't appear that I have. Each time I restart the services, I am...

Yes on the account. This is a previously working installation that has suddenly decided to fail. Did verify account was working properly and reset all services appropriately.

Not sure how...

More notes on this issue;

Once a mail task fails I can't repeat can't kill the process. Once I stop SQLServerAgent, it won't restart, stays in starting mode perpetually. Have...