Right now I have one table of members with table primary key 'id' as auto incremented.

I want that instead of auto increment, it will **generate a random integer of 5-6 digits** and put that as '**id**'. As every 'id' is primary key so generated int will be unique. Any ideas to implement this on sql server will help.