Competition: What’s your favorite Redgate tool? Enter now.

Creating an update script Issue

swebberswebber Posts: 2
edited October 23, 2006 6:22AM in SQL Packager Previous Versions
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

Comments

  • Hi

    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
    Daniel Handley
    Red Gate Software Ltd
Sign In or Register to comment.