Isn't that part of what I just said ?

Dolphin Look at MY post on the previous thread.

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=199015

1.

For each BEGIN TRAN the variable @@trancount is incremented by 1

For each commit is decremented by one

If rollback is encountered...

To be honest ALL your questions are anwsered in that article but if you need my views here we go:

I am struggling with the best way to handle this situation. ...

how about the activity on both servers?

I don't think the difference can be that marked (few hours vs few minutes) when that is the case either the source and...

what happens when you use something like:

@declare @stm = 'exec linkedservername.dbname.dbo.procname'

create table #T(fld1 int, fld2 ....)

insert into #T(fld1,fld2,...)

exec(@stm)

Do you have any firewall in between the servers?

the first thing I would try is to make sure that all the users in the db map to the corresponding login on the new server.

have a look at :...

I like hepling people while learning myself doing it especially when the quizes tend to be chanllenging but couldn't care less what the outcome is.

Now if there are free t-shirts out there......

may I ask, why do you need a temp table ?

There have been days in which I wished I have

Have a look: Implementing Error Handling with Stored Procedures

Have a look at SSIS ... and read all about it

I hope that he knows that QA = Query analyzer

and

I hope that he can write : exec spname in the Passthrough query

and

I hope that he creates an ODBC...

>>Everybody knows you don't drive nails with a screwdriver, that's what monkey wrenches are for! <<

Well, I have to admit that I have 

I assumed he meant that the SP was in SQL Server .... and I was right