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 tableExecution of this procedure prevent errors in DTS Import/Export wyzard : Copy objects and data between SQL Server databasesexec refresh_all_views_in_order -- in current database and all dependencies are ok […]
2003-02-13
413 reads
By SQLPals
This is a simple powershell script to query and display hardware and OS information...
Whether you’re a DBA/administrator looking to tune a server, planning for hardware updates, or...
By Bert Wagner
Watch this week’s episode on YouTube! I nearly always use execution plans as the...
Comments posted to this topic are about the item Evergreen SQL Server
Comments posted to this topic are about the item Do you really know what’s...
Comments posted to this topic are about the item Going from long to wide
Ask SSC