Post reply

problems with stored procedure recreation ANSI_NULLS, QUOTED_IDENTIFIERS

  • March 10, 2004 at 10:06 pm

    #160644

    I am having problems with recreation of stored procedures using generated scripts.

    Problem arises when i recreate (another test) database with generated script created using SQL Enterprise manager or some time when using actual developement database . The stored procedure scripts contain some scripts setting server options (for every stored procedure) like SET ANSI_NULLS ON/OFF and SET QUOTED_IDENTIFIERS ON/OFF with every stored procedure. now when executing those stored procedures some of those crashes... and due to hell lot of stored procedures i cannot actually spend time correcting those to right settings. now tell me what actually is the problem and what options are needed to be set for SQL Server / Connections (in Query Analyser) to get rid of this messy thing.

    Regards.

    Rehan Ahmad Rattu

    - Rattu

  • March 11, 2004 at 5:59 am

    #498253

    Perhaps you are using indexed views and the Arithmetic Abort setting (should be on) differs between servers or the Compatibility Level (should be 80) differs between databases.



    --Jonathan

  • March 11, 2004 at 1:42 pm

    #498369

    I get around this by chooseing the option to only script 7.0 compatible features.  The scripts will then not contain any of that extra stuff

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

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