You can change things like this all day long very easily in SQL 7, but not
6.5. What you'll need to do, is create a new column in that table (DataNew
as an example) with the length that you need. I have mine set to 100. Then
using ISQL/w:
update radconfigs
set DataNew = Data
That will copy over the data from the Data column to the DataNew column.
Afterward, you can rename the Data column to DataOld and rename DataNew to
Data.
You may need to restart RadiusNT afterward, also.
Once you verify that things are working correctly, you may want to "clean
up" the RadConfigs table:
update radconfigs
set DataOld = ''
That won't serve any functional purpose, but cleans it up a bit for your own
sake and makes the table a little bit smaller (not enough to really make any
difference though). In SQL 6.5, you cannot remove the DataOld column--or
any other for that matter.
No matter how you look at it, SQL Server 7 is a VAST improvement over 6.5.
SQL Server 2000 is in Beta 2 at the moment.
Josh
For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart