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')