>>Hi Naomi.
>>
>>>Are you sure SDT has nothing to do with this? E.g. would it be safe for me to just apply changes again on the production DBC and not on the devdata where we keep the tables and fields definitions?
>>
>>SDT doesn't touch your stored procedures at all unless you specifically turn on SDT database events, in which case we append some code. Yes, you can add stored procedures to your database at any time.
>>
>>Doug
>
>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.