Re: Altering a Table

Dale Reed ( )
Mon, 29 Jun 1998 16:44:24 -0700

Gregory White wrote:
> I would like to increase the length of the login column in the subaccounts
> table. Enterprise Manager will not let me as far as I can tell.

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.  (       IEA Software, Inc.      |  RadiusNT, Emerald, and NT FAQs Internet Solutions for Today  |