User Profile

Collapse

Profile Sidebar

Collapse
pizzab
pizzab
Last Activity: Jun 26 '10, 02:36 PM
Joined: Jun 20 '10
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • pizzab
    replied to How to use Trigger to update the data from linked server
    in SQL Server
    Thanks ck9663 for your reply,

    For replication, is it using sql to do so or using sql server 2008 express interface. I am a newbie. If possible, could you please indicate me with related web link. Once again, thanks for your help.

    Regards,
    pizzab...
    See more | Go to post

      Leave a comment:

    • pizzab
      replied to How to use Trigger to update the data from linked server
      in SQL Server
      Thanks for your reply. I have a SQL server 2008 database on Windows Server 2003. The database data is actually from a link server by using SQL insert statement. I want to make a trigger that when there is some update on the linked server, the data on my SQL server 2008 database will be update. I am a newbie on trigger. Thanks for your help in advance....
      See more | Go to post

        Leave a comment:

      • pizzab
        started a topic How to use Trigger to update the data from linked server
        in SQL Server

        How to use Trigger to update the data from linked server

        I am using SQL server 2008 express on Windows Server 2003. I have a linked database. The linked server is using Sql server 2005 on Windows server 2000.

        I want to use a trigger on the sql server 2008 express to update my data in the database of Windows Server 2003 if there is any data change on the linked database.

        Your help will be appreciated.
        See more | Go to post
        No activity results to display
        Show More
        Working...