• Figured it out, thanks for pointing me in the right direction, I just right clicked the triggers in the remlactation table and clicked on new trigger, followed the step by step and replace all with what I wanted.

    Final result was this... tested and working...

    USE [Lely]

    GO

    /****** Object: Trigger [dbo].[A2FixTeatCoordinates] Script Date: 04/09/2014

    11:27:58 ******/

    SET ANSI_NULLS ON

    GO

    SET QUOTED_IDENTIFIER ON

    GO

    -- =============================================

    -- Author:<Author,,Name>

    -- Create date: <Create Date,,>

    -- Description:<Description,,>

    -- =============================================

    CREATE TRIGGER [dbo].[A2FixTeatCoordinates]

    ON [dbo].[RemLactation]

    AFTER INSERT,DELETE,UPDATE

    AS

    BEGIN

    -- SET NOCOUNT ON added to prevent extra result sets from

    -- interfering with SELECT statements.

    SET NOCOUNT ON;

    -- Insert statements for trigger here

    UPdate dbo.PrmMilkVisit

    Set MviLFXPosition = 60, MviLFYPosition = 660, MviLFZPosition = 510, MviLRXPosition =

    30, MviLRYPosition = 780,

    MviLRZPosition = 520, MviRFXPosition = -70, MviRFYPosition = 670, MviRFZPosition = 500,

    MviRRXPosition = -30,

    MviRRYPosition = 790, MviRRZPosition = 520

    Where MviLFXPosition = 0 AND MviLFYPosition = 0 and MviLFZPosition = 0 and

    MviLRXPosition = 0 and MviLRYPosition = 0

    and MviLRZPosition = 0 and MviRFXPosition = 0 and MviRFYPosition = 0 and MviRFZPosition

    = 0 and MviRRXPosition = 0

    and MviRRYPosition = 0 and MviRRZPosition = 0

    END

    GO