We transfer multiple tables to our MS SQL Server 2000 machine and then have a stored procedure use the contents of the transferred table.

All goes well as long as our end user has typed less than 255 characters into their Access memo field. At this point it is as if SQL isn't quite sure what the data is and makes it ntext. We've tried using the CAST function in SQL to ensure it works but this fails too.

Does anyone know how SQL actually interprets this Access request?