I have a database that I am moving to SQL server and one of the tables is using a Memo field. I have been told that we have limited space on the Server so I am trying to be mindful of the data types in SQL server. I am looking for suggestions on what the data type should be for an Access Memo field.
It has been suggested to use either text or varchar for the field in SQL server. Is there a way that I can query the current table to figure out the longest number of characters in the MEMO field. If so can you please provide assistance with it?