Bug? - SQLCompare 6.1 doesn't refresh views with drop column

slhaleslhale Posts: 6
It appears that if a table is only altered by dropping one or more columns, SQLCompare 6.1.053 does not generate sp_refreshview statements for assciated views causing the following error when one of those existing views is accessed:

Msg 4502, Level 16, State 1, Line 1
View or function '<view>' has more column names specified than columns defined.

Comments

  • slhale wrote:
    It appears that if a table is only altered by dropping one or more columns, SQLCompare 6.1.053 does not generate sp_refreshview statements for assciated views causing the following error when one of those existing views is accessed:

    Msg 4502, Level 16, State 1, Line 1
    View or function '<view>' has more column names specified than columns defined.

    Many thanks for reporting this. I have raised this as a bug, and we will fix this in a future version.

    Regards,
    Andras
    András Belokosztolszki, PhD
    Red Gate Software Ltd.
  • Eddie DEddie D Posts: 1,800 Rose Gold 5
    I am pleased to inform you that we have fixed this problem in the recently released SQL Compare V.7.

    If you have a valid Support & upgrades option, you can download SQL Compare V.7 using the 'Check for updates' mechanism (SQL Compare GUI ->Help ->Check for updates)

    or download using this link: HERE

    SQL Compare V.7 will install along side any previous versions of the software.

    Many Thanks
    Eddie
    Eddie Davis
    Senior Product Support Engineer
    Redgate Software Ltd
    Email: support@red-gate.com
Sign In or Register to comment.