Home Forums SQL Server 2008 SQL Server 2008 - General Alter the schema from one view causes the need to alter the other RE: Alter the schema from one view causes the need to alter the other

  • November 28, 2014 at 7:21 am

    #1761434

    Yes, normal and documented. You need to run sp_refreshview on both. Or stop using SELECT *

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass