I had made some alterations in the structure of a database, so i executed a schema comparison with another similar DB. I generated the differences script and executed it from within Studio. It said it had "finished successfully", but when i re-compared the structure, i saw the same differences as before. I re-executed the script in SSMS and saw that it failed in a "sp_refreshview" call.

Two problems here:

1. Why did Studio failed to catch that a change was needed in that view?

2. Why did studio report that the script had executed fine, even though the "sp_refreshview" call had failed?