MyLittleSQL Admin won't let me change datatype in a table

For some reason, my column that was designated as a "char" type is now listed as a "text" type inside my MS SQL2000 database, and I cannot change it back to "char" type when going to Edit that particular column. The error I get:




Error -2147217900





Cannot alter column 'state' because it is 'text'.


ALTER TABLE [DB_292589_ufcpp].[dbo].[county_details] ALTER COLUMN [state] CHAR(2) NULL


..it seems this just happened all of a sudden by itself (??)


MGregory
unionsazcom

Post Edited (ch99) : 11/17/2006 8:19:33 PM GMT