>Hi Larry,
>
>Do you have many simultaneous users? I'm just concerned about contention on the PK table. I realize it should be a quick lock and release, but in a couple of my triggers, I need to get a new PK which may the lock for a second or two. I haven't finished writing the trigger (I have another unanswered question up here...), but that is one of my concerns.
>TIA,
The system where I implemented this was a web-based time entry system. In answer to your question, there are about 50 people hitting it at the same time every 2 weeks. Not very many really.
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao