SCHEMABINDING issues

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

SCHEMABINDING issues

Postby anna.p » Fri Aug 23, 2013 2:05 am

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!
anna.p
 
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