I have been experiencing issues when making schema changes/stored proc definition changes. The changes that I make are not always persistent. I can make a change today then a day or two later I'll find out that the bug the change was fixing is still occuring. When I check the schema/stored proc my changes are nowhere to be found it will be just as it was before. Then I make the change again and usually it takes the second time around, but there have been a couple of instances where the second change has also reverted.
We're running SQL Server 2008 (10.0.6000.29)
I just wanted to find out if anyone else may have experienced this or might have a suggestion for a solution.