I had a similar requirement. I have posted the approach I used on my blog here

http://codejotter.wordpress.com/2010/02/23/generate-random-and-unique-alphanumeric-code/

thanks for the reply. i will try it and post the result.

It seems that you are on 2000. I am using 2005 !

i am having the same problem... help.. anyone !