>>>Doug,
>>>
>>>I made a change again and the same thing happen again. For few days it was using my new version and right now it somehow reverted back to the original SP. I believe we did update the structure through SDT.
>>
>>Hi Naomi,
>>
>>if I understand the sequence of events properly:
>>
>>Day 1: make a change in SDT and update database
>>Day 2 - 3: everything fine.
>>Day 4: old stored procedures start being used
>>
>>It sounds like some is restoring your old database/stored procedures on day 4.
>>
>>I have been using SDT for many many years and never had a problem with SPs getting changed.
>
>We're using some special utility written by my former colleague to update our database based on SDT. I'm not exactly sure what this program does. In any case, just to be safe I updated both - out developement database SP and our production DB SP. Hopefully it would take care of the problem now.
Sounds like you need to ensure that update utility is doing the right thing, otherwise this will come back and bite you or somebody else when they don't update both databases with the adjusted SPs