DECLARE @s varchar(2000);

SET @s = 'INSERT INTO timestmp(tablename,fieldname,recordid,timestamp,oldvalue)'
SET @s = @s + 'SELECT '''+ @tbname + ''','''+@fieldname+''',  , now(), ' + @fieldname + ' FROM ' + @tbname
SET @s = @s + 'WHERE   = ' + @Identity

EXECUTE @s;

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go





ALTER  TRIGGER [InsTrigger] ON [dbo].[emrn]
FOR INSERT
AS
BEGIN
SET NOCOUNT ON

DECLARE @tbname varchar(100)
DECLARE @fieldname varchar(50)
DECLARE @id varchar(100)
DECLARE @s varchar(2000)

select @tbname = 'emrn'

DECLARE triggeredfields CURSOR
FOR 
	SELECT fieldname 
	FROM dbconfig
	WHERE tablename =@tbname AND triggered = 1

OPEN triggeredfields

FETCH NEXT FROM triggeredfields INTO @fieldname



WHILE (@@FETCH_STATUS = 0)
	BEGIN
		SELECT @id = (SELECT emrn_id FROM inserted)
		
		SET @s = 'INSERT INTO timestmp(tablename,fieldname,recordid,timestamp,oldvalue) '
		SET @s = @s + 'SELECT '''+ @tbname + ''','''+@fieldname+''','+@id+', now(), ' + @fieldname + ' FROM ' + @tbname + ' '
		SET @s = @s + 'WHERE emrn_id = ' + @id

		EXECUTE @s;

		FETCH NEXT FROM triggeredfields INTO @fieldname
	END
					
CLOSE triggeredfields
DEALLOCATE triggeredfields

END

Der Name 'INSERT INTO timestmp(tablename,fieldname,recordid, [timestamp],oldvalue) SELECT 'emrn','emrn_name',3,now(), emr_name FROM emrn WHERE emrn_id=3' ist keine gültiger Bezeichner.

EXECUTE (@s);