That's another great question .

That's also another great reason to have a formal code implementation method in place.

Sorry but I'm feeling lazy... what about those insert statments?

Can you repost the whole scrit?

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).