Ansi_nulls

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Sandeep - 01 Dec 2004 20:12 GMT

We had a stored procedure that was created while
ansi_nulls was on. Is there a way to tell if SP has any of
the ansi settings changed from default? Just curious.

Sk

Reply to this Message

Jacco Schalkwijk - 02 Dec 2004 15:02 GMT

SELECT OBJECTPROPERTY(OBJECT_ID('<procedure name>'), 'ExecIsANSINullsOn')

1 is on, 0 is off.

Signature

Jacco Schalkwijk
SQL Server MVP

> We had a stored procedure that was created while
> ansi_nulls was on. Is there a way to tell if SP has any of
> the ansi settings changed from default? Just curious.
>
> Sk

Reply to this Message

- 02 Dec 2004 15:24 GMT

Thanks a million Jacco.

SK

>-----Original Message-----
>SELECT OBJECTPROPERTY(OBJECT_ID('<procedure name>'), 'ExecIsANSINullsOn')
[quoted text clipped - 8 lines]
>
>.

Reply to this Message