Creating an update script Issue
swebber
Posts: 2
When creating an update script it seems to run "exec sp_refreshview"
How do i stop this as it causes a problem because it trys to refresh vws that dont get exist in the database that is being updated
In the tool it says that
Refresh view [dbo].[rpt_elementscoresatcompetency]
How do i stop this
How do i stop this as it causes a problem because it trys to refresh vws that dont get exist in the database that is being updated
In the tool it says that
Refresh view [dbo].[rpt_elementscoresatcompetency]
How do i stop this
Comments
The sp_refreshview is included in the SQL compare engine because if a table is changed and you have a dependant view that uses select 8 the information will to be updated in the metadata and the view will not reflect any changes.
In your circumstance the view does not exist and so the script does not behave as expected.
Did your original target database have the views in?
Did you uncheck the include dependencies option?
Regards
Dan
Red Gate Software Ltd