Post reply

About alter statement

  • June 3, 2008 at 12:15 am

    #77003

    About alter statement

    We have rolled out a new version of an application.

    We used alter statement to modify some of our stored procedures.

    When we viewed them in production it is looking like modified one.

    But when application is executing, its referencing old SP only

    I guess the older version is still referenced.

    Can someone help us on this?

  • June 3, 2008 at 12:18 am

    #823421

    Maybe your new procedures arent compiled?

  • June 3, 2008 at 12:25 am

    #823423

    First check whether u have alter rights,

    then check with the procedures correctly that the changes made by u were reflected in it, by taking the SP from database.

    if not alter the procedure again,

    check whether u have made some changes in talbe or triggers, if so do that changes too...

    Hope it will work fine now.

    Thanks - Raja

  • June 3, 2008 at 12:28 am

    #823425

    try sp_helptext, this will give you the procedure as it is on the database

  • June 3, 2008 at 12:32 am

    #823426

    Make sure the app is pointing at the right database.

    Make sure that you don't have 2 copies of the procedure in different schemas

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • June 3, 2008 at 5:54 am

    #823540

    And in addition to making sure the App is pointed at the right database, make sure you are.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

Viewing 6 posts - 1 through 5 (of 5 total)

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