how can an id be duplicated...

what's the primary key of the table??

Can you post the table definition so we can show you the exact script?

Still no luck with

SET @MyAmount = 627 --Select sum(Value) from MyTable where value % 2 = 1

SELECT @MyCol = MAX(Col)+1 FROM MyTable

It happens only for objects that require a script to work (views/functions/sps...)

[Farrell's version]

Doesn't work in this case :

DECLARE @MyAmount NUMERIC(12,2)

DECLARE @MyCol int

SET @MyAmount = 627 --Select sum(Value) from MyTable where value % 2 = 1

SELECT @MyCol = MAX( Col)...

To sum up : yes it's true .

It wouldn't solve the problem... the trigger still has to finish before giving the control back to the proc...

this could come in handy :

WAITFOR DELAY '00:00:01' --wait 1 second then resume the script

if you have a view named view1 and you rename it with EM (or with sp_rename), the script will still go as :

CREATE VIEW dbo.view1...

You have to change that...

Is there a way to make to trigger run faster?

Can we see the code?

yes but its seems to be embeded into its own script... hard to tell where this behavior comes from.

We don't have many yellers here.. you should be ok .

Ya, I'll hold my breath... (30 M peeps in here).

Wrong house, got 2 cats and a dog.

Maybe you can simply create a linked server. Then an instead of insert trigger would do this :

insert into LinkedServer.DbName.owner.Table (col1, col2, coln) Select col1, col2, coln from dbo.Inserted

First time I read that... I'll see what others have to say about this.