Jampandu (11/26/2014)
we are planning to use above series as primary key instead of identity column.
I didn't read this part. Using this as a primary key won't give you any benefits. You'll need 7 bytes instead of 4 used by the int and you'll reduce the number of values available. If you use it as an alternate key just to have a "more readable" key, you can keep it as a calculated column that won't use any space and you don't have to use it as foreign key in any other tables.