Do you have any samples of Database Triggers?

 

Solution:

 

Sample Trigger Update Event:

 

CREATE TRIGGER EMPLOYEE_EMPID ON DBO.EMPLOYEE FOR UPDATE

AS

IF UPDATE(EMP_ID)

exec master.dbo.xp_cmdshell '"c:\Program Files\Vineyardsoft\KnowledgeSync 2000\Bin\KS_Event.exe" @admin;password/schedule=pubs_event'

GO

 

 

Sample Trigger Insert Event:

 

CREATE TRIGGER EMPLOYEE_EMPID ON DBO.EMPLOYEE FOR INSERT

AS

IF UPDATE(EMP_ID)

exec master.dbo.xp_cmdshell '"c:\Program Files\Vineyardsoft\KnowledgeSync 2000\Bin\KS_Event.exe" @admin;password/schedule=pubs_event'

GO

 

 

 

 

Below is a link to our Knowledgebase which is constantly being updated with new information, technical tips and resolutions. 

For future questions, please refer to the Knowledgebase first to see if it contains the information you need.

http://vineyardsoft.com/support_knowledgebase.php

 

Please download the Award Winning KnowledgeSync manual.  

It is a total solution and reference guide which contains comprehensive information on setup, configuration, queries, reports, actions and every aspect of KnowledgeSync possible. 

http://vineyardsoft.com/downloads-documentation.php

 

-Your Vineyardsoft Technical Support Team