Red Gate forums :: View topic - SCHEMABINDING issues
Return to RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Compare 10
SQL Compare 10 forum


Search in SQL Compare 10 forum
Post new topic   Reply to topic
Jump to:  
Author Message

Joined: 03 Jul 2012
Posts: 23

PostPosted: Fri Aug 23, 2013 2:05 am    Post subject: SCHEMABINDING issues Reply with quote


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!
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

Powered by phpBB © 2001, 2005 phpBB Group