SCHEMABINDING issues

anna.panna.p Posts: 34
edited August 22, 2013 9:05PM in SQL Compare Previous Versions
Hello,

We have a lot of views with SCHEMABINDING.

It often happens that SQL Compare will miss a dependency and attempt to alter a table referenced by a schema bound view without first altering the view to remove the SCHEMABINDING.

This doesn't happen all the time; I'd say 70% of the dependencies are caught and 30% aren't.

How does SQL Compare determine when a view needs to be altered to remove SCHEMABINDING? Is there some system table it checks? If so, maybe we have inconsistencies in that system table?

It's getting a little frustrating having to add 2 ALTER VIEW statements manually to a bunch of build scripts... :-/

I'm normally using the GUI, by the way.
Any ideas would be appreciated!
Sign In or Register to comment.