Lost now.

SQL 2005 - use update statistics

sql 2000 - sp_updatestats

I thought it was the other way around and that the sp_updatestats will only update the statistics that are...

i ran this

Create PROCEDURE dbo.SP_UpdateStatsALL

AS

Set Nocount on

Declare db Cursor For

Select name from master.dbo.sysdatabases where name = 'APPDBX'

--not in ('master','TempDB', 'msdb', 'model')

Declare @dbname varchar(60)

Declare @execmd nvarchar(150)

Open db

Fetch Next...

Thanks...

Lastly what do you guys use as your percentages with the statement

sp_updatestats

Fulls - i be there until xmas......................

One table i saw sampled 10098562 how do you know which sample...

Thats good the index statistics check..

getting names called

clust

NULL

clst

nc1

nc2

is it possible to get table also printed out.

Yes some are out of date .... 🙁

The last time i ran was when...

What parameters do you use on your twice daily.

I was under impression that the index will do the statistics so it only be on the tables that need to be...

Hmm is thinking over here.

(Thats a good idea set up multiple publishers - to the same subscriber database).

That prevent time out.

I was thinking that the static tables - i could...

Thanks and for the updates on replication

Never really thought about that hmmm now im thinking over here why replicate all 1500 some of these are static tables and never change perhaps i rethink that only the...

Yes basically how did you determine the two were out of sync i.e Publisher table was 100 and the subscription table was 90.

So did you use the script - tablediff...

About 1500 tables

Ok i got the file created.

Now if you run it to update just a single table in the subscriber this wouldnt have a problem with the replication.

Now the script is...

i did have a look at the threads

Our version is

Microsoft SQL Server 2005 - 9.00.3228.00 (X64) Feb 9 2008 09:33:32 Copyright (c) 1988-2005 Microsoft...

Thanks i will review

transacational.

1. create a pub with at least one article

2. generate replication script (drop+create)

3. edit script to have many articles

4. execute script

So the script you mention is...