I have a ColdFusion app that is dynamically managing a SQL Server 2K database. What I am running into is the need to change a column data type - specifically an ntext data type. Anybody got any suggestions? It appears that I cannot used ALTER TABLE/COLUMN with an ntext data type, so what other options are there? Is there a clean way to create a new nvarchar column for example, then copy and truncate all of the info in the ntext column, then delete the ntext column? Thanks for any pointers. -- Jeff
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm