Post reply

Ansi_null settings in procedure

  • September 28, 2004 at 6:57 am

    #59523

    Hi,

    Is there any way of finding the settings that a procedure was loaded with? Specifically, I would like to know whether a procedure was loaded with the settings:

    ANSI_NULL ON/OFF

    QUOTED_IDENTIFIER ON/OFF

    In Enterprise Manager, I can use the "Generate script"-option to get the settings. But I would like to create a script to check this for me...

  • September 28, 2004 at 3:51 pm

    #524715

    See the sql help on OBJECTPROPERTY function.

     

     

  • September 29, 2004 at 3:29 am

    #524754

    Thanks John,

    That was just what I needed!

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply