How to Create a Trigger on Linked Server Table

• info-658497

  SSC Veteran

  Points: 252

  More actions

  February 18, 2009 at 10:10 am

  #218579

  Hi all,

  I have a backend inventory App which uses DBF files. I'm creating a web frontend Product catalog using SS 2K5.

  I successfully created a linked server to the DBF files, and can query them, except that for large tables, it takes a long time (I've tested with both Jet and FoxPro providers).

  I'd like to maintain an "image" of the DBF files locally in SS tables, but I would like them to always be in sync.

  Is it possible to create triggers on the linked server as to monitor activity on the DBF files? For example, if a recond is inserted in Products.dbf, the trigger would insert in dbo.Products.

  Thanks in advance for any help

• RBarryYoung

  SSC Guru

  Points: 143329

  More actions

  February 18, 2009 at 12:42 pm

  #946232

  Not in SQL Server.

  [font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
  Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]

• JH-320775

  Newbie

  Points: 5

  More actions

  March 26, 2009 at 10:13 am

  #966815

  I have the EXACT same situation.

  If you find a solution, please let me know and I will do the same.

  BTW, I am linking DBF III files and I found that the Jet Ole db driver is faster than the VFPOLEDB Driver.

  Also, I can't insert/update with the foxpro driver but i can with the jet driver.

  Select * statement on dbf file with 25,000 records.

  foxpro 18 seconds

  jet 7 seconds