• You can use the below mentioned query to find all un-encrypted routines using "TABLEA.ID"

    SELECTOBJECT_NAME(object_id) AS RoutineName

    FROMsys.sql_modules AS sm

    WHEREsm.definition LIKE '%TABLEA.ID%'

    You can then manually changes all the SP's

    I would suggest you to do some documentation of the procedures involved and make the changes carefully even if it takes a lot of time.


    Kingston Dhasian

    How to post data/code on a forum to get the best help - Jeff Moden
    http://www.sqlservercentral.com/articles/Best+Practices/61537/