Connecting to MSSQL server with a linked server

Instead of doing a SELECT * list your columns and CAST the problematic column.

3 Likes