Originally Posted At: http://weblogs.asp.net/alex_papadimoulis/archive/2004/05/18/134106.aspx

Naturally, all tables referencing tblState link with a column “intStateID”

Now, I don't know about you, I think you'd be a fool to implement this any other way. Think about it, what happens if a state descides to change it's name and abbreviation ... and the database you moved to when this happens does support update triggers? Can you really afford to take that risk? I didn't think so!

[Advertisement] BuildMaster allows you to create a self-service release management platform that allows different teams to manage their applications. Explore how!