Thank´s a lot for the information!

Tomas

Thank's

I have this, do I need the commit or is the transaction automaticly rolled back if I go in to Catch section?

What do you think about this code?

BEGIN TRY

BEGIN TRANSACTION

UPDATE...

Used Profiler and did not see anything wrong but I saw that the trigger code generated multiple rows, look here:

INSERT INTO tblArtiklar (idFaktura,Receiver,Artikelnummer,Artikeltext,Antal,Pris)

...

I can see it in the table B.

Here is the trigger:

ALTER TRIGGER [FidInsertRecordsToArtikles]

ON [dbo].[TblWebArtikles]

AFTER INSERT

AS

DECLARE @err int

BEGIN

DECLARE @p1 varchar(50)

DECLARE @idFakt...

Thank's!

/Tomas

Thank's all of you! It gave me many tips to solve the problem!

Tomas

Thanks Roy. I use Sql server authenticating.

Regards

Thank's ! Think a do one sp for every table.

Regards

Tomas

I have GW too, but I use a way to sent the mail to the SMTP server in GW. Has a rutine for it if you want to try. Send...