One of the common problems that you would encounter when you are building applications that utilize views is that sometimes there are cases wherein a view gets out of date. This happens when you add a new column to a table a view is refrencing. To fix this some people would delete the view and recreate...
Posted to
Keith Rull
by
keithrull
on 08-19-2008
Filed under: SQL, SQL Tricks, SQL Helpers, SQL Tips, sp_refreshview