• 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