Microsoft SQL Server forum - sql server and membership provider

Author

sql server and membership provider

Amir Ghezelbash

2006-02-19, 3:23 am

Hello all,
I need help with sql server which i was wondering if someone can shed
some light on my problem

The problem:
Hello all,
I need help with sql server which i was wondering if someone can shed
some light on my problem

The problem:
i am using .net 2.0 membership provider interface to provide a
membership in my website...now i also am using the sql server 2005 for
the backbone of the site..now when a new user is created their
information is saved into asp_ membership and their userid is
automactially saved into another table called asp_users...now these are
defaults by membership provider...what i would like to do is to create
another table which i have called "Rank" and i would a column in this
"rank" table that would keep the user ids, now i have noticed that the
asp_user.UserId has a releationship with asp_Membership.userId so when a
new user is created asp_user.Userid automactially gets updated..i have
created a colum called Rank.UserId which has a relationship with
asp_users.userid and asp_membershi.Userid but it doesnot get updated
automatically when a new user is created...what can i do so i can have
this table "Rank" also gets updated automactially as soon a a new user
is created or a user has been deleted...just like asp_users gets updated
...thanks in advance

---
Best Regards
Amir

---
Best Regards
Amir

*** Sent via Developersdex http://www.droptable.com ***

Erland Sommarskog

2006-02-19, 9:23 am

Amir Ghezelbash (amir_gh99@hotmail.com) writes:
> The problem:
> i am using .net 2.0 membership provider interface to provide a
> membership in my website...now i also am using the sql server 2005 for
> the backbone of the site..now when a new user is created their
> information is saved into asp_ membership and their userid is
> automactially saved into another table called asp_users...now these are
> defaults by membership provider...what i would like to do is to create
> another table which i have called "Rank" and i would a column in this
> "rank" table that would keep the user ids, now i have noticed that the
> asp_user.UserId has a releationship with asp_Membership.userId so when a
> new user is created asp_user.Userid automactially gets updated..i have
> created a colum called Rank.UserId which has a relationship with
> asp_users.userid and asp_membershi.Userid but it doesnot get updated
> automatically when a new user is created...what can i do so i can have
> this table "Rank" also gets updated automactially as soon a a new user
> is created or a user has been deleted...just like asp_users gets updated
> ..thanks in advance

I know zero about ASP .Net, and even less about any membership provider,
but it sounds as if you want a cascading foreign key:

ALTER TABLE Ranks ADD CONSTRAINT fk_rank_userid (UserId)
REFERENCES asp_Membership (userId) UPDATE ON CASCADE

--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx

Sponsored Links