I have a numeric field that the client wants to be text now. I right-click, choose modify, and change it from type int to text (I also tried ntext). I am doing this in SQL Server Management Express. The database uses Windows Authentication. I get the error message:
conversion from 'int' to 'text' is not supported on the connected database server
What do I need to do? Thanks!