This procedure refresh all views of current database in good order to recreate correct dependencies lost after updating views.
This procedure just call sp_refreshview and uses temporary table
Execution of this procedure prevent errors in DTS Import/Export wyzard : Copy objects and data between SQL Server databases
exec refresh_all_views_in_order
-- in current database and all dependencies are ok
I have tested this procedure in SQLSERVER 2000
Get a summarized report of all DataBases options
This SELECT will give you a summarized report for the options selected for ALL the databases on your SQL Server. It's compatible with versions 7 and 2000.
2002-07-11
648 reads