DECLARE UpdateStatisticsTables CURSOR READ_ONLY FOR
02  SELECT sst.name,
03         Schema_name(sst.schema_id)
04  FROM   sys.tables sst
05  WHERE  sst.TYPE = 'U'
06DECLARE @name   VARCHAR(80),
07        @schema VARCHAR(40)
08 
09OPEN UpdateStatisticsTables
10 
11FETCH NEXT FROM UpdateStatisticsTables INTO @name, @schema
12 
13WHILE ( @@FETCH_STATUS <> -1 )
14  BEGIN
15      IF ( @@FETCH_STATUS <> -2 )
16        BEGIN
17                DECLARE @sql NVARCHAR(1024)
18        SET @sql='UPDATE STATISTICS ' + Quotename(@schema)
19                           +
20                           '.' + Quotename(@name)
21                  EXEC Sp_executesql @sql
22        END
23 
24      FETCH NEXT FROM UpdateStatisticsTables INTO @name, @schema
25  END
26 
27CLOSE UpdateStatisticsTables
28 
29DEALLOCATE UpdateStatisticsTables
30 
31GO