Post reply

SET ANSI_WARNINGS OFF

  • March 27, 2008 at 2:04 am

    #183649

    Hi all

    i have an sp it showing erroe

    SET ANSI_WARNINGS OFF

    but in sp which porson i have to write

    ex:

    Set ansi_nulls on

    Set ansi_warnings on

    go

    Create Procedure YourProcedure ....

    but this is showing create should be first line

    pls help me

    hari

  • March 27, 2008 at 6:03 am

    #794527

    I'm not 100% positive, but I think SET ANSI_WARNINGS ON can go INSIDE the stored procedure (after the CREATE), so that when the SP runs, it sets ANSI_WARNINGS ON for that SP.

    You can also set it at the database level (ON or OFF), and that applies to all objects. To that you use user options for sp_configure.

    If it was easy, everybody would be doing it!;)

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

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