Unfortunately, you can't in SQL Server. The two options you have is
to rebuild the table (like bcp the info out, break the relationships,
re-create the table, and bcp the information back in, and re-create
the relationships. The other option is to rename the old column and
create a new one with the login name. I wish there was an easier
way. :(
-- Dale E. Reed Jr. (daler@iea-software.com)_________________________________________________________________ IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs Internet Solutions for Today | http://www.iea-software.com