Use an instead of trigger to work around this problem.
Something like:
CREATE TRIGGER [PostalAreaInsertTrigger]
ON [PostalAreaView]
INSTEAD OF INSERT AS
BEGIN
DECLARE @cur CURSOR
SET @cur = CURSOR FOR
SELECT
[Oid],
[RegisteredTime],
[RegisteredBy],
[SystemTypeId],
[Region],
[Name],
[FromTime],
[ThroughTime]
FROM inserted
OPEN @cur
DECLARE @Oid uniqueidentifier
DECLARE @RegisteredTime DateTime
DECLARE @RegisteredBy uniqueidentifier
DECLARE @ObjectType int
DECLARE @Region uniqueidentifier
DECLARE @Name nvarchar(255)
DECLARE @FromTime DateTime
DECLARE @ThroughTime DateTime
FETCH NEXT FROM @cur INTO
@Oid,
@RegisteredTime,
@RegisteredBy,
@ObjectType,
@Region,
@Name,
@FromTime,
@ThroughTime
WHILE(@@fetch_status <> -1)
BEGIN
EXEC [PostalAreaInsert] @Oid,@RegisteredTime,@RegisteredBy,@ObjectType,@Region,@Name,@FromTime,@ThroughTime
FETCH NEXT FROM @cur INTO
@Oid,
@RegisteredTime,
@RegisteredBy,
@ObjectType,
@Region,
@Name,
@FromTime,
@ThroughTime
END
CLOSE @cur
DEALLOCATE @cur
END
GO
The code above is for inserting records, but it's similar for update
Regards
Espen Harlinn