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
418 reads
By Steve Jones
I’ve started to add a daily coping tip to the SQLServerCentral newsletter, which is...
By Steve Jones
I’m doing a webinar next week, on Wednesday, April 15, 2020, that looks at...
By Steve Jones
I wrote yesterday about the issues with SSMS 18.5 and some of the add-ins...
While configuring N1 and N2 Nodes connected to DC Domain Controller working fine. Establishing...
Comments posted to this topic are about the item Do You Have a Mentor?
Comments posted to this topic are about the item Counting Rows in DAX
Ask SSC