Antares686,

> Wrapping all the logic in Proc means no

> update to the data and only the INSERT is

> recorded.

Are you sure about that?

I ran SqlProfiler with a stored proc...

Agreed that timeouts are better than deadlocks.

My approach would be to set transaction isolation level to read committed and have a reasonable lock timeout value. Depending on the kind of...

Antares686,

As long as you maintain a transaction, this will work very well.

Since the trigger will increment the value to 1 if there is no record in the table, you will...

Hmm, am a bit puzzled as to why you all wish to use a stored procedure when a simple insert trigger will do the job :

CREATE TRIGGER TI_zMaster ON zMaster...

Nice article, provokes one into taking a second look at 'taken-for-granted' jobs.

--

Diwakar