Doug:

What I do is setup a SP on SQL Server that servers as a counter. When the client app starts up, it places a call to this SP and returns a unique number. Subsequent keys are the generated on the client by concatenting a key generated locally with the key recieved on startup. This method aviods a lot unecessary round trips to the server.

Charlie