Bonnie, you were right my compatibility level was 65.

I set it to a higher version by running the below command and that solved the problem.

> sp_dbcmptlevel vips version, 80



thanks for your advise.

Sergio