How do you persist enumerations in SQL Server?
And for those of you really looking to the future, how do you do it for SQL Server 2005? If I understand it right, since you can use your own types in the database, it sounds like a good idea to do just that. What I'm not sure of is how you deploy the enumeration from your humble dozen lines of code to something that lives in the database.