title: Syntax for SQL Trigger to Insert Data in another DB and also to update any field in another db adfter a field is edited
body: <p>Here is the scenario - I will be specific.  I have a "bridged" DB on Sql Called [Fulcrum_Xfer] I use this bridged because the Main Db called [Fulcrum UAT] is using a bigint datatype for some fields and thereby displaying in my Access front end "<em>#Deleted data</em>" in all fields - This behavior CANNOT be changed in the present design (the bigint has to stay) so I have the exact table name and fieldnames in my [Fulcrum_Xfer] DB - the OrderNO field in Orders table in [Fulcrum_Xfer] is int and there is no primary key</p>
  
  <p>What I need to have done by tomorrow under threat of some "you let us down" is the following</p>
  
  <p>the table that initially gets data inserted or updated into is called Orders and is in the [Fulcrum_Xfer] database that structure is as follows</p>
  
  <pre><code>OrderNo                int              Unchecked
  OrderDate              smalldatetime    Unchecked
  ApplicationTenantLinkId int             Unchecked
  OrderStatus             int             Unchecked
  </code></pre>
  
  <p>the table that receives the triggered data from Orders in FulCrum_Xfer is called Orders and it is in Database Fulcrum UAT 
  The structure is </p>
  
  <pre><code>OrderNo                bigint           Unchecked  Primarykey 
  OrderDate              smalldatetime    Unchecked
  ApplicationTenantLinkId Bigint          Unchecked
  OrderStatus             int             Unchecked
  </code></pre>
  
  <p>I need two trigger statements that will insert a new record into Orders in [Fulcrum UAT] after I insert it into Orders in [FulCrum_Xfer]</p>
  
  <p>and</p>
  
  <p>I need a trigger that will update any field in Orders in [Fulcrum UAT] when I make a change in Orders in [Fulcrum_Xfer]</p>
  
  <p>I do not know where the trigger goes other than maybe Database Triggers in [FulCrum_XFer]  but I get freaked out by the template syntax (do not think I need all that) and I do not know how to write the syntax for each task</p>
  
  <p>I am a very experienced VB / VBA developer and have used ADO for building and calling stored procedures on SQL but have never had to do this type of task on the SQL Server - please do not treat me like a dunce - but this is very important in my job right now.</p>