script_update_statistics


DELETE scripts
WHERE name = 'script_update_statistics'
GO
INSERT scripts 
VALUES('script_update_statistics','SET NOCOUNT ON')
INSERT scripts 
VALUES('script_update_statistics','DECLARE @table varchar(30)')
INSERT scripts 
VALUES('script_update_statistics','DECLARE object_cursor CURSOR FOR')
INSERT scripts 
VALUES('script_update_statistics','SELECT name FROM sysobjects')
INSERT scripts 
VALUES('script_update_statistics','WHERE type = "U"')
INSERT scripts 
VALUES('script_update_statistics','OPEN object_cursor')
INSERT scripts 
VALUES('script_update_statistics','FETCH NEXT FROM object_cursor INTO @table')
INSERT scripts 
VALUES('script_update_statistics','WHILE (@@fetch_status <> -1)')
INSERT scripts 
VALUES('script_update_statistics','  BEGIN')
INSERT scripts 
VALUES('script_update_statistics','    IF (@@fetch_status <> -2)')
INSERT scripts 
VALUES('script_update_statistics','      BEGIN')
INSERT scripts 
VALUES('script_update_statistics','        PRINT @table')
INSERT scripts 
VALUES('script_update_statistics','        EXEC ("UPDATE STATISTICS " + @table)')
INSERT scripts 
VALUES('script_update_statistics','      END')
INSERT scripts 
VALUES('script_update_statistics','    FETCH NEXT FROM object_cursor INTO @table')
INSERT scripts 
VALUES('script_update_statistics','  END')
INSERT scripts 
VALUES('script_update_statistics','PRINT "Statistics have been updated for all tables."')
INSERT scripts 
VALUES('script_update_statistics','CLOSE object_cursor')
INSERT scripts 
VALUES('script_update_statistics','DEALLOCATE object_cursor')