I run the following query as a job. It's supposed to give me an update
as to where it is
In the process. In other words as it loops I know which table is
currently updating statistics.

exec sp_MSforeachtable
@command1 = 'print ''updating statistics on table ?''',
@command2 = 'update statistics ? with fullscan',
@whereand = 'and name like ''tbla%''',
@precommand = 'Print ''UPDATING STATISTICS STARTED '' ',
@postcommand = 'Print ''DONE UPDATING STATISTICS ENDED'' '
Go

If I kill the job I don't get anything, And the file the job writes to
is not updated.

Any Ideas?

Thanks!

Russ

This e-mail and any files transmitted with it are for the sole use of the intended recipient(s) and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient(s) is strictly prohibited. If you received this in error, please contact the sender by reply e-mail and destroy all copies of the original message.

MS Sql Server LazyDBA home page