How to detect the current settings of ANSI_NULLS?

Hello All.
How to detect the current settings of ANSI_NULLS at run-time of script?
For example:
SET ANSI_NULLS OFF - sets ANSI_NULLS to OFF
GO
GET ANSI_NULLS - gets the settings of ANSI_NULLS.Hi
dbcc useroptions
<burlaka@.yandex.ru> wrote in message
news:1143625595.136842.163590@.t31g2000cwb.googlegroups.com...
> Hello All.
> How to detect the current settings of ANSI_NULLS at run-time of script?
> For example:
> SET ANSI_NULLS OFF - sets ANSI_NULLS to OFF
> GO
> GET ANSI_NULLS - gets the settings of ANSI_NULLS.
>|||Thank you very much.

How to detect and add exceptions to Firewall programmatically?

I've been successful at installing a customized SQLexpress using setup.exe /settings template.ini.

What I'd like to do now is see if I can progammatically detect a Firewall on the SQLexpress machine and if there is one to add the exceptions for sqlservr and sqlbrowser programmatically so that the user doesn't have to do anything.

Is this possible and how would I do it?

Thanks,

jerry

You'll have to use the Windows Firewall API to do this. There is a topic on adding Program Exceptions here.

Mike

|||

Thanks Mike... that puts me on the right track.

/jerry