Post reply

Change SPs QUOTED_IDENTIFIER in block...

  • October 12, 2012 at 4:54 am

    #265620

    Hi,

    I've a database with 635 SPs. 495 have QUOTED_IDENTIFIER OFF and 140 have ON.

    Is there any way of getting the SP code add QUOTED_IDENTIFIER ON and recreate the SPs?

    Does the sys.sql_modules have all the code from the SPs? We have some BIG SPs...

    Thanks,

    Pedro


    If you need to work better, try working less...

  • October 12, 2012 at 2:11 pm

    #1548829

    Yes, sys.sql_modules is all you need.

    _____________________________________________________
    Microsoft Certified Master: SQL Server 2008
    XDetails Addin - for SQL Developers
    blog.sqlxdetails.com - Transaction log myths

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

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