Add files via upload

aduguid · web-flow · commit dd65643df972 · 2017-10-16T15:09:14.000+11:00
diff --git a/SSDB.Script_Refresh_Views.sql b/SSDB.Script_Refresh_Views.sql
@@ -0,0 +1,8 @@
+SELECT DISTINCT 
+'EXEC sp_refreshview ''' + sc.name + '.' + so.name + '''' AS IndividualScript
+FROM sys.objects AS so 
+INNER JOIN sys.schemas sc ON sc.schema_id = so.schema_id
+INNER JOIN sys.sql_dependencies AS sed 
+    ON so.object_id = sed.object_id
+WHERE       so.type = 'V' 
+--AND OBJECT_NAME(sed.referenced_major_id) LIKE 'MyTable%'
