Query to find out the SPs having hardcoded values.

Last post 09-05-2008 12:31 AM by FrankKalis. 1 replies.
Page 1 of 1 (2 items)
Active Topics My Discussions Unanswered Sort Posts: Previous Next

  • 09-05-2008 12:04 AM

    Query to find out the SPs having hardcoded values.

    Locked Reply Contact

    Hi,

    I need to know if there is some query which would pull up all the SPs where the hardcoded values have been used from a particular DB.

    For example if we have a Database as sales and we have some 20 SPs under this database out of these 20 SP we have used hardcoded values in 5 SPs. So i need to know the query which would pull up these 5 SPs having a hardcoded value.

    Thanks,

    Varsha

  • 09-05-2008 12:31 AM In reply to

    Re: Query to find out the SPs having hardcoded values.

    Locked Reply Contact

     Please do not multipost. Continue here: http://sql-server-performance.com/Community/forums/t/28089.aspx

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Contributing Editor, Writer & Forum Moderator http://www.sql-server-performance.com
    Webmaster: http://www.insidesql.org
    View Frank Kalis's profile on LinkedIn

    XING
Page 1 of 1 (2 items)
Active Topics   My Discussions    Unanswered Posts


© 2000 - 2007 vDerivatives Limited All Rights Reserved.