A. You can use the OBJECTPROPERTY function :
select objectproperty(object_id('<spname>'), 'ExecIsAnsiNullsOn')
This returns 1 for yes, 0 for no
0 comments
Hide comments
A. You can use the OBJECTPROPERTY function :
select objectproperty(object_id('<spname>'), 'ExecIsAnsiNullsOn')
This returns 1 for yes, 0 for no