I have the same issue.  I followed the steps outlined to fix it, but i get the same error afterwards.  Any idea what else I can do?

I am not familiar with how one would accomplish this.  Can you expound?

thanks.

The error is retrieved from the job history of the particular job that is failing.

Executed as user: sa. MSDTC on server 'ACS_RAC_SRV3' is unavailable. [SQLSTATE 42000] (Error 8501)  The operation...

no clustering.  Simple machines with sql server installed on it.  Just two db servers.  Happens that we use the one for archiving data from production.

the first few times i ran it, i got errors that i dont remember.  But now, it passes the dtcping just fine.  unless rpc is turned off or something. 

but...

DUH!  how lame of me to not remember (nolock).

thanks.

Thanks also to Ferguson.  Thanks as well for the code that was sent.  I have not yet tried it, but look forward...

here's one of my favorite examples of using dynamic sql to get something, and get the result of it in a proc.

create procedure spGetCount

@TableName varchar(100) = null,

...

you mentioned a free product from eeye.com, but not the name. Unfamiliar with their products, i could not find the one you were talking about. Could you let us...

cool to know. thanks guys. I was worried because it didnt display it correctly.

alls well, i paniked for nothing. But I'd rather do that, then...

It does start out like you said. I dont pretend to understand it all, but i dont see anything in it that raises any flags in my head.

about a...

just out of curiosity, what is the purpose behind this exercise?

I admit, its an intruiging prospect that has me stumped, and I'd love to see a solution or...

A coworker of mine found the solution authored by Kevin Sun (kv_sun@microsoft.com). He did a google search and found it.

-------------

Restore data when ldf is corrupt and sp_attach_single_file_db won’t work.

Did...

The database is not attached, so we cannot try dbcc rebuild_log. But we were finally able to reattach it by creating a new blank db, stopping the server, then...

the client had 7 and recently has upgraded to 2000. Its just a timed backup of the entire db. Stock backup that comes in scheduler.

I am about to...

I have created a series of stored procs that get hierarchical data from a customer table. It is for mlm trees. Me, who i signed up, who they...