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
414 reads
When studying Azure one of the things you’ll be asked to learn is the...
I’ve written about statistics in SQL Server a few times now. Through conversations I...
Recently I noticed that Microsoft uploaded a new dockerfile to the mssql-docker repository on...
Comments posted to this topic are about the item Is Data the Future of...
I'm using AlwaysOn synchronous replica. User issues an update on primary via SSMS. In...
hi, i'm creating a view and need some help. i have the column "valorTotal"...
Ask SSC