Re: Username length

Pat Augustine ( ereth@ilnk.com )
Fri, 25 Apr 1997 12:31:19 -0400

>SQL Server doesn't have an easy way of doing field changes like this.

That explains why I couldn't find one.

>There
>are two options which I details to the list a while back:
>
>1) If its a small number of records in the table, then you can rename
>the field
>to like field_old, and add a new field with the fieldname and the right
>size. YOu
>have to re-create your DRI stuff, though.
>
>2) use bcp to copy the table out of SQL Server into a file, then change
>the def
>and copy it back in.
>

I had assumed as much, but was hoping I was wrong. Oh, well, thanks, at
least I know I'm not overlooking something.

Pat Augustine
Interlink America