Please open BOL on CHECKSUM and read 2nd paragraph of "Remarks".

Once again:

ALL DELETED ROWS ARE IN THE TABLE "DELETED".

Just use my code as it is.

Please read the manual, BOL in this case.

Topic CREATE TRIGGER.

Table deleted contains only deleted records.

CREATE TRIGGER [TRIGDelete] ON [dbo].[TableA]

FOR DELETE

AS

INSERT INTO TableB (Column List)

SELECT Column List

FROM deleted

GO

Trigger is a transaction by itself.

It's a part of the transaction which fired the trigger.

It will commit/rollback its own transaction automatically depending if there was an error during execution.

You cannot...

What are the data types for e.num_dist and e.bb_ind ?

Google "book on line SQL2000" (if you don't have MSDN page bookmarked) and in no time you'll be on this page:

http://msdn.microsoft.com/en-us/library/aa299742(SQL.80).aspx

That simple.

Try

REPLACE(STR(ID, 9), ' ', '0')

It's not the way it's stored, it's the way it's presented to you on SELECT.

If you want another presentation use CONVERT or STR functions.

But use them only for presentation, not...

You've already posted alternative method.

Why don't use it?

Look at the name of the topic YOU opened.

You listed 2 solutions.

One of them does not work.

So?

The problem must be in the query you're exporting.

Must be a lot of functions which return NVARCHAR, not CHAR as you think.

After that find that guy who told you to...

If you try to execute it it will say you its wrong.

And it's overcomplicated.

What you need the transaction for?

Do you do any data modification here?

My version would look like this:

Alter...

Does you inline query actually work?

Replace exec(@SEQ) with

PRINT @SEQ

-- exec (@SEQ) -- uncomment when it's debugged

Helps a lot.