I'm just attempting to consider a procedure I want where I've:

  1. One SQL 2008 express database on the webserver - takes orders into an orders table
  2. Another SQL 2008 express database on another webserver serving as a after sales system to process the orders etc

The concept since the webserver database could be left to complete what it really does, and just whenever a new order record is placed (really up-to-date.. another area of the story) I needed that row to become placed for an orders table on another server...

The 2 servers will have local IP addresses, and therefore are basically on a single subnet - i.e. can communicate easily enough...

Just working out if your SQL Trigger is what you want, or have i got possibly a scheduled job around the second server which queries the very first server say every 5 mins (plenty, very few orders) and card inserts any new orders into it's own database.. the concept may be the table within the source/first server has a little area to point in the event that row continues to be seen/read by server two...

Any ideas? regrettably it's all regulated SQL 2008 R2 express at this time...

You wouldn't want a trigger being able to access another server included in a transaction. One solution, is by using Service Broker possess the trigger place a note in to the the neighborhood queue, and because of the other server use of this queue.

SQL Server Service Broker offers the SQL Server Database Engine native support for texting and queuing programs. This causes it to be simpler for designers to produce sophisticated programs which use the Database Engine components to speak between disparate databases. Designers may use Service Broker to easily build distributed and reliable programs.

You have to educate yourself on connecting servers first. This should actually be a great article that you should begin with. Even better, the scenario it describes is really fairly much like yours. Also, replication between your two servers might be superior to triggers. Here is a link for an article doing exactly that.