In Sql Server 2000 Version, I found that no Notification message box appears when converting text column to varchar but the data gets truncated to the given size for the varchar. Whereas it appears when you convert the varchar column to text column.
Do this through Enterprise Manager Console
Create a New table with a column as varchar datatype from Enterprise Manager table created Open the table and add one row Successfully added the row Open the table in Design Mode Change the datatype to text and click on save Gives Notification: 'test' table- Warning: Data may be lost converting column 'test' from 'varchar(255)'. Successfully changed the column form varchar to text
Create a New table with a column as text datatype from Enterprise Manager table created Open the table and add one row with data length greater than 255 (long text) Successfully added the row Open the table in Design Mode Change the datateype to varchar(255) and click on Save Successfully changed the column from text to varchar Open the table and verify the row data. Data got truncated to length 255 without any notifications
WHY??????????
Do this through Enterprise Manager Console
Create a New table with a column as varchar datatype from Enterprise Manager table created Open the table and add one row Successfully added the row Open the table in Design Mode Change the datatype to text and click on save Gives Notification: 'test' table- Warning: Data may be lost converting column 'test' from 'varchar(255)'. Successfully changed the column form varchar to text
Create a New table with a column as text datatype from Enterprise Manager table created Open the table and add one row with data length greater than 255 (long text) Successfully added the row Open the table in Design Mode Change the datateype to varchar(255) and click on Save Successfully changed the column from text to varchar Open the table and verify the row data. Data got truncated to length 255 without any notifications
WHY??????????