• mstjean (2/8/2010)


    ...when I needed to refresh all views, I was used to create the script with all DROP and CREATE for all views,...

    If/when you do this-- be sure you grab the permissions before dropping. Why not use ALTER instead?

    Yes, you are right! But the script wizard of SSMS allow you just to do DROP and/or CREATE script for all views, and not the ALERT... 😉 This is the reason...

    And also b/c if I drop and create all views, I'm absolutely sure that the they are created in the right order.

    Bye,

    Flavio.