Jeff,

This is not a pay per response site, it is mostly peers offering the odd snippet of experience to help out others. If you truly require immediate response, why not...

Might be better using this:

create

table #enum_job (

Job_ID

uniqueidentifier,

Last_Run_Date

int,

Last_Run_Time...

what is the max degree of parelism set on the server itself?

Check this NB out http://support.microsoft.com/?kbid=873160 to make sure that the two MSDTC services can talk

what operating system are the boxes on, is the msdtc service configured so the two can talk?

you could use xp_fileexist extended stored procedure, search this web site and you should see how to use it.

I believe you need a firm grounding in SQL before moving into writting SPs, maybe look at the book SQL Queries for mere mortals, less about SQL Server and more...

SQL uses sp_MSdependencies SP to get this info, if you run

sp_helptext sp_MSdependencies you can see what is in the SP and presumably cobble together what you need.

This should work

DECLARE @sp_type int

SET @sp_type =5

SELECT * FROM

sales

WHERE Cur_date >

 case WHEN @sp_type= 5 THEN DATEADD(mm,-1,getdate())

 WHEN @sp_type=6 THEN DATEADD(mm,-2,getdate())

 ELSE DATEADD(mm,-3,getdate())

 END

Easy way to do a quick check is to open query analyzer on domain you are connecting from and issue a sql statement against the domain you are trying to...

is the msdtc service running on both boxes, is there a firewall between them or could one of the boxes be on a dmz?

There is an extended Stored Procedure

xp_getnetname that will give you the machine name.

Is the database in full recovery mode if not it will need to be, if you have chosen all databases (including system) then the failure will be due to the...

What recovery model is the database in?

Are there any open transactions on the base, use

dbcc opentran

If there are these might be bloating the log, if so you may need to kill...