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
441 reads
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
If you’re reading this, there’s a good chance you’re straight, white, male, and English-speaking....
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
I have a SqlAgentJob calling a stored proc. that loops through a list of...
I know that there is a query you can run in SQL to search...
Hi all, 99% sure the answer to this question is "it is not possible",...
Ask SSC