CODEWITHSUNDEEP
sql-serversql-server-2008configure
Igor Borisenko
Igor Borisenko

Reputation: 3866

How to view default values of the SET options of a server

I read BOL but could not figure it out.

When i exec sp_configure it shows just enter image description here

Here I can not see if NOCOUNT or ANSI_WARNINGS are SET ON by befault. How can I do that?

Thanks.

Upvotes: 3

Views: 1627

Answers (2)

gbn
gbn

Reputation: 432331

You have to enable "show advanced options" and run RECONFIGURE

The server defaults are all zero (nothing set) by the way. Your client or driver sets options automatically that will override any server defaults you set

See this for more: Who do @@OPTIONS and sp_configure provide different output?

Upvotes: 1

Aaron Bertrand
Aaron Bertrand

Reputation: 280383

You can see the defaults here:

http://msdn.microsoft.com/en-us/library/ms190707.aspx

You can check your own settings using:

DBCC USEROPTIONS;

And you can check any other session's settings using various columns in sys.dm_exec_sessions.

Upvotes: 6

Related Questions