A. Just like sp_recompile works for stored-procedures there is a way (with 7.0 and above anyway) to do this for views :-
sp_refreshview <viewname>
It is trivial to write a cursor round sysobjects and then run this automatically via EXEC (..) to refresh all views in a database.
0 comments
Hide comments