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.