why two fields "email" and "lowered email" in table aspnet_memebership?

#1

Hi,

in table aspnet_membership of ASPNETDB.MDF, there are two fields "email" and
"lowered email" with the same value for each user.

Can somebody tell me what's the function of that second field?

Thanks
Dan

#2

Hello,

Mostly I feel that there will be a trigger it updates the Lowered email
column. Just run SP_DEPENDS on the table aspnet_membership and
see if there is any trigger.

Thanks
Hari

"Dan" <danperrt (AT) nomaol (DOT) nl> wrote

Quote:

Hi,

in table aspnet_membership of ASPNETDB.MDF, there are two fields "email"
and "lowered email" with the same value for each user.

Can somebody tell me what's the function of that second field?

Thanks
Dan

#3

thanks
"Hari Prasad" <hari_prasad_k (AT) hotmail (DOT) com> schreef in bericht
news:ejbJ8JbgHHA.4596 (AT) TK2MSFTNGP05 (DOT) phx.gbl...

Quote:

Hello,

Mostly I feel that there will be a trigger it updates the Lowered email
column. Just run SP_DEPENDS on the table aspnet_membership and
see if there is any trigger.

Thanks
Hari

"Dan" <danperrt (AT) nomaol (DOT) nl> wrote in message
news:Og39OFagHHA.3852 (AT) TK2MSFTNGP04 (DOT) phx.gbl...
Hi,

in table aspnet_membership of ASPNETDB.MDF, there are two fields "email"
and "lowered email" with the same value for each user.

Can somebody tell me what's the function of that second field?

Thanks
Dan

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

why two fields "email" and "lowered email" in table aspnet_memebership?

microsoft.public.sqlserver.setup microsoft.public.sqlserver.setup

why two fields "email" and "lowered email" in table aspnet_memebership? - 04-18-2007 , 05:07 AM

Re: why two fields "email" and "lowered email" in table aspnet_memebership? - 04-18-2007 , 07:08 AM

Re: why two fields "email" and "lowered email" in table aspnet_memebership? - 04-18-2007 , 09:15 AM