Is the DTC service running on the remote system? 

Can you make a call to the remote SP outside of the trigger?

No, but given your situation, I would just do what "rhunt" described above.

<quote>Can I still achieve this functionality if I create/alter the table the way you suggested?</quote>

Don't have the solution, but I noticed that you specified 'C:\Database\Backup\TestBackup.bak' in your first "RESTORE FILELISTONLY" statement, then later 'C:\Projects\ASDOS\DataBase\TESTBackup.bak' and then finally 'C:\Projects\ASDOS\DataBase\TEST.bak' in the error message.  Each of these has...

Well,

OK I'm curious why you want to have two columns that contain exactly the same information -- seems unnecessary, redundant, and it violates basic normalization principles.

Must you have a constraint...

Well here's an example using code I use to fill a combo box ["lbDBA"].  May not be the most efficient, but it certainly works.  I take the easy approach and choose...

Well, I was trying to think of a possible workaround myself, but the prev. poster is really asking all the right questions here.  

You really need to think about the answers...

Might be easier if you just write to a SQL table.

Here's some quick 'n dirty code for you.  I just took a S.W.A.G. at the field lengths in...

See post here:

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

To investigate the problem further, I would run SQL Profiler and see what syntax is being issued from VB.NET.

Extract the line with the Transact SQL command from profiler and try executing it...

Well, without knowing too much other than what you've described:

I would try to avoid loading (potential) duplicate records in the final table, and then having to perform processing to remove the dups. It would be better to insert only the...

Well, I haven't worked with merge replication per se, but I've seen this type of error in other replication scenarios.

If I recall correctly, we need to make sure the account the SQL...

I wouldn't try to use a global temporary table--or a temporary table at all for that matter if you are going to be doing BCP.  Use a permanent table.

You can name...

Another (basic) approach that I like to use is to force the case on both sides of the equation.  Not rocket-science or anything, but it works:

SELECT * FROM FinCenters

WHERE UPPER(FC_NAME) LIKE...

You may want to shoot me, but what you've described could almost be implemented using a merge replication scenario.  See BOL if interested... 

OK.

If you're that concerned about "Select into" vs "delete from" or "insert into" performance, then it sounds like you need another strategy. 

I suggest you create a multi-step SQL Agent job to do...