Federation key issue

85 Views Asked by At

I have to design a database for customer with email id as login but since we have lots of data we need to use federation but since we cant have string or varchar or nvarchar as federation key I am stuck at what should I do. User will use email id to login. How can I solve this problem? Please help me.

1

There are 1 best solutions below

3
On

You can use varbinary column, and populate the varbinary column with the hash of the email address.

IMHO using an email address as a Federation key does not seem like a good design idea though