|
|
|
|
|
DECLARE
UpdateStatisticsTables CURSOR
READ_ONLY FOR |
03 |
Schema_name(sst.schema_id)
|
06 |
DECLARE
@ name VARCHAR (80),
|
09 |
OPEN
UpdateStatisticsTables |
11 |
FETCH
NEXT FROM UpdateStatisticsTables
INTO @ name , @ schema |
13 |
WHILE ( @@FETCH_STATUS <> -1 )
|
15 |
IF ( @@FETCH_STATUS <> -2 )
|
17 |
DECLARE
@sql NVARCHAR(1024) |
18 |
SET
@sql= 'UPDATE STATISTICS '
+ Quotename(@ schema )
|
20 |
'.'
+ Quotename(@ name ) |
21 |
EXEC
Sp_executesql @sql |
24 |
FETCH
NEXT FROM
UpdateStatisticsTables INTO
@ name , @ schema |
27 |
CLOSE
UpdateStatisticsTables |
29 |
DEALLOCATE
UpdateStatisticsTables |
|
|