Viewing 2 posts - 1 through 2 (of 2 total)
Update statistics by default samples 25 percent of the data in the table to generate statistics full scan generates statistics based on your entire data(all rows).
Hope this helps
May 12, 2011 at 7:33 am
#1323654
Why don't you try to identify the tables from sysobjects
and use a cursor to use sp_addarticle for each of this tables.
The other thing that you can do is to...
April 15, 2011 at 6:03 pm
#1312398