ok, I've worked out the following three stored procs (through trial and error) Feedback and criticism welcome!

USE [DotNetNuke]
GO
/****** Object: Trigger [dbo].[CopyToMap] Script Date: 04/14/2011 14:57:40 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author: Roland Kamsika
-- Create date:
-- Description:
-- =============================================
ALTER TRIGGER [dbo].[CopyToMap]
ON [dbo].[grmRepositoryObjects] FOR INSERT
AS
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with caller queries SELECT statements.
-- If an update/insert/delete occurs on the main table, the number of records affected
-- should only be based on that table and not what records the triggers may/may not
-- select.
SET NOCOUNT ON;

--
-- Variables Needed for this Trigger
--
DECLARE @GUID nvarchar(200)
DECLARE @SourceID int
DECLARE @Address nvarchar(300)
DECLARE @IconIndex int
DECLARE @Description nvarchar(150)

--
-- Table INSERTED is common to both the INSERT, UPDATE trigger
--
SELECT
@SourceID = 1,
@GUID =[ItemID],
@Address = CONVERT (nvarchar(300),[DESCRIPTION]),
@IconIndex = 0,
@Description =CONVERT (nvarchar(150),[NAME])
FROM [dbo].[grmRepositoryObjects]

BEGIN
INSERT INTO [Map_Points]
([SOURCEID]
,[GUID]
,[ADDRESS]
,[ICONINDEX]
,[DESCRIPTION])
VALUES
(@SourceID
,@GUID
,@Address
,@IconIndex
,@Description
)
END



USE [DotNetNuke]
GO
/****** Object: Trigger [dbo].[DeleteFromMap] Script Date: 04/14/2011 14:58:21 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author: Roland Kamsika
-- Create date:
-- Description:
-- =============================================
ALTER TRIGGER [dbo].[DeleteFromMap]
ON [dbo].[grmRepositoryObjects] FOR DELETE
AS
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with caller queries SELECT statements.
-- If an update/insert/delete occurs on the main table, the number of records affected
-- should only be based on that table and not what records the triggers may/may not
-- select.
SET NOCOUNT ON;

--
-- Variables Needed for this Trigger
--
DECLARE @GUID varchar(MAX)
DECLARE @SourceID int
DECLARE @Address varchar(MAX)
DECLARE @IconIndex int
DECLARE @Description varchar(MAX)

--
-- Table INSERTED is common to both the INSERT, UPDATE trigger
--
BEGIN

SELECT @GUID= (SELECT ItemID FROM Deleted)

DELETE FROM Map_Points
WHERE Map_Points.GUID = @GUID

END




USE [DotNetNuke]
GO
/****** Object: Trigger [dbo].[UpdateToMap] Script Date: 04/14/2011 14:58:40 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author: Roland Kamsika
-- Create date:
-- Description:
-- =============================================
ALTER TRIGGER [dbo].[UpdateToMap]
ON [dbo].[grmRepositoryObjects] FOR UPDATE
AS
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with caller queries SELECT statements.
-- If an update/insert/delete occurs on the main table, the number of records affected
-- should only be based on that table and not what records the triggers may/may not
-- select.
SET NOCOUNT ON;

--
-- Variables Needed for this Trigger
--
DECLARE @GUID varchar(MAX)
DECLARE @Address varchar(MAX)
DECLARE @Description varchar(MAX)

--
-- Table INSERTED is common to both the INSERT, UPDATE trigger
--
BEGIN

SELECT @GUID= (SELECT ItemID FROM Inserted)

SELECT
@Address =grmRepositoryObjects.DESCRIPTION,
@Description= grmRepositoryObjects.NAME
From grmRepositoryObjects join Map_Points on grmRepositoryObjects.ItemID = @GUID


UPDATE Map_Points
SET ADDRESS=CONVERT (nvarchar(MAX),@Address),
DESCRIPTION=CONVERT (nvarchar(MAX),@Description),
LONGITUDE=0,
LATITUDE=0,
FAILEDGEO=NULL

WHERE Map_Points.GUID = @GUID

END