c29a6b67   
   From: esquel@sommarskog.se   
      
   Johnnyb (john.lutheran@gmail.com) writes:   
   > OK, I am a total novice, it is the 'Do Something Here' part I am stuck   
   > on. I want to copy just the row into s different database on a different   
   > server.   
      
   INSERT SERVER.dataase.dbo.tbl(....)   
      SELECT ....  FROM inserted   
      
   Where you previously have defined the linked server with sp_addlinkedserver.   
      
   However, there are two different complications here.   
      
   One is what you exactly mean with "copy". Does that other table have the   
   same schema? What if there already is a row with the same key value? Or is   
   this not an issue?   
      
   The other is the fact you the table is on a different server. It may all go   
   smoothly. Or it may give you one hell of a headache to get working. It may   
   work for one user, it may fail for another.   
      
   If you give the full plot of why you want to copy this row and in what sort   
   of environment you are working in, we might be able to give your more exact   
   advice.   
      
      
   --   
   Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se   
      
   Books Online for SQL Server 2005 at   
   http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx   
   Books Online for SQL Server 2000 at   
   http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)