All Alpha User Fields going to SQL 2005 as nvarchar(max)
I just noticed that in my SBO 2005 SP01 working with MS SQL 2005, that no matter how long in the UDF tool I create an alphanumeric field for (ie. 15, 20, 30), in SQL the column format is nvarchar(max) instead of char(15), char(20), char(30).
This is causing me major trouble in Crystal. I can't group by a nvarchar(max) field, nor can I link these to any other table.field.
Has anyone encountered this? Is there something that can be changed or are we doing something wrong?
I appreciate any insight you may have...