>Hi Naomi.
>
>>I made some changes directly in the database's SP using MODIFY PROCEDURE command. I see now that my changes got overwritten. What is the proper way to adjust SP using SDT?
>
>SDT doesn't do anything with stored procedures other than adding to them if you turn on database events in SDT. In what way were your changes overwritten? Was the entire set of code replaced with something else or was it just one or a few procedures?
>
>Doug
I don't have the procedure saved anywhere. I made the changes and for ~about 2 weeks everything worked correctly. Then recently we started to receive the same errors as before and I see that all my changes are overwritten. I think we updated the database structure recently through SDT.
Do you know how should I update my SP to make sure it will preserve?
If it's not broken, fix it until it is.
My Blog