By the way, Our product communicate with SQL Server using TDS protocol, we do not really care about how long varchar(max) and nvarchar(max) columns can hold.
I'm willing to cut the 'dba' some slack because frankly if there's one thing I've learned over time is that with there being SO much to learn we tend to...