• ben.brugman - Monday, February 26, 2018 7:45 AM

    Grant Fritchey - Monday, February 26, 2018 7:33 AM

    Best way to do this is to put your database code into source control. You can track it and version it that way. Further, once you start treating your database as code, you can start to automate deployments since builds from source control allow you to go from a known state.

    Thanks Grant Fritchey.
    Tracking changes of the content. Or changes of the data returned by the view.
    Not the 'source' of the view.

    I think that your anwser reveres to changes in the 'definition'. Or am I misunderstanding your anwser ?
    Thanks for your time and attention,
    Ben

    Sorry, you said changes in "content" not data or the code. I misunderstood what content meant. Gail has the better answer for this. It's all about tracking the data in the tables. There is no data in a view. It's just a query.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning