Thanks for your reply. Yes I already have a working set of code that accomplishes everything. My goal was to use the built in sequences available in Server to accomplish what my procedure does in conjunction with a set of stored procedures to implement my Key generator. My hope was to be able to eliminate my Counters Table from my database and gain some much needed experience using the various aspects of what Server has to offer. I'm a fairly accomplished database designer and have used Access and Oracle in the past but my experience with Server is basically book knowledge. The key gen code for my project world be a nice test case for using Stored Procedures and Sequences and would eliminate a large piece of client-side code. I will certainly look at the link you provided and thanks again.