Posted by Erland Sommarskog on 10/01/10 11:40

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/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]