Compares and synchronizes SQL Server databases, backups and scripts.
Moderators: JonathanWatts, Chris Auckland, David Atkinson, eddie davis, Anu Deshpande, Michelle Taylor, alice.easey, james.billings, chengvoon.tong
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!
- Posts: 23
- Joined: Tue Jul 03, 2012 10:59 pm
Return to SQL Compare 10
Who is online
Users browsing this forum: v_itsoft02 and 1 guest