How can I tell if a stored procedure was created with the ANSI NULLS setting on?

Neil Pike

December 18, 1999

1 Min Read
ITPro Today logo in a gray background | ITPro Today

A. You can use the OBJECTPROPERTY function :

select objectproperty(object_id(''), 'ExecIsAnsiNullsOn')

This returns 1 for yes, 0 for no

Sign up for the ITPro Today newsletter
Stay on top of the IT universe with commentary, news analysis, how-to's, and tips delivered to your inbox daily.

You May Also Like