• yes there's a stong chance anything which truncates a guid or uses the rnd function will generate a duplicate.

    [font="Comic Sans MS"]The GrumpyOldDBA[/font]
    www.grumpyolddba.co.uk
    http://sqlblogcasts.com/blogs/grumpyolddba/