ANSI_WARNINGS
ANSI_NULLS
CONCAT_NULL_YIELDS_NULL
AnsiNPW=no -- works in ODBC Ansi warnings=off -- puts into Extended properties attribute and adds several other parameters as well, but no effectWell, I say no effect - in SQL Profile, the Audit Login for connections show that warnings are on, and there is no batch after (like from a VFP SPT connection) that then sets them off, nor does it show if this is an existing connection.