Default connection settings - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

Default connection settings

Author

Topic

peteh
Starting Member

8 Posts

Posted - 2009-05-12 : 18:34:51

Is there an easy way to determine the default connection settings SQL server will use for new connections?

I'm particularly interested to know what the values are for these:

ANSI_NULLS ON
ANSI_PADDING ON
ANSI_WARNINGS ON
CONCAT_NULL_YIELDS_NULL ON
QUOTED_IDENTIFIER ON
NUMERIC_ROUNDABORT OFF
ARITHABORT ON

Pete

robvolk
Most Valuable Yak

15732 Posts

Posted - 2009-05-12 : 18:58:49

[code]SELECT SESSIONPROPERTY('ANSI_NULLS') -- 1 = on, 0 = off[/code]SESSIONPROPERTY() is documented in Books Online.