ANSI 92 COMPLIANCY CHECKLIST v7.0
Due to Microsoft's past nonadherence to ANSI SQL standards, they have 
provided a series of options for maintaining backward compatibility as 
well as options to go forward with SQL 92 compliancy on v7.0. According 
to Microsoft Press Inside SQL Server v7.0, these options need to be set 
in order to comply with SQL 92.

1. Use SET ANSI_NULLS ON: This disables the equal null (= NULL) 
capability in prior versions.
2. SET ANSI_WARNINGS ON: This would turn on the behavior of divide-by-
zero, string too large for database column, and other similar errors 
being raised.
3. SET ANSI_PADDING ON: This is the default behavior for SQL Server. Do 
not trim trailing blanks entered in varchar columns.
4. SET IMPLICIT TRANSACTIONS ON: Statements are implicitly part of a 
transaction; it requires COMMIT and ROLLBACK.
5. SET ARITHABORT ON: This quits query if divide-by-zero or overflow 
occurs.
6. SET CURSOR_CLOSE_ON_COMMIT ON: This closes any open cursors when a 
COMMIT is issued; SQL keeps these open for reuse by default.
7. SET QUOTED_IDENTIFIER ON: Single tic's (') and double quote marks 
(") are treated differently.
8. SET ANSI_NULL_DFLT_ON ON: By default, create as NOT NULL a column in 
a CREATE TABLE statement. This is done at table creation with the 
current setting.

You can set most of these as a group by issuing the SET ANSI_DEFAULTS 
ON/OFF. The SET ARITHABORT ON would have to be set additionally.
DBCC USEROPTIONS will return information about how your session-
specific settings are configured.

-------------------------------------------