Update Stats Question

[Ed75]

I am currently using the following script to update stats on all of my databases.

DECLARE @table_name varchar(1000),@sql nvarchar(4000)

declare c1 cursor for SELECT name

FROM sysobjects

WHERE xtype = 'U'

open c1

fetch next from c1 into @table_name

while @@Fetch_Status = 0

begin

Select @sql = 'UPDATE STATISTICS '+ @table_name +' WITH FULLSCAN'

--print @sql

exec sp_executesql @sql

fetch next from c1 into @table_name

end

close c1

deallocate c1

GO



One of my databases is coming up saying

Msg 2706, Level 16, State 6, Line 1
Table 'HEATSym' does not exist.

Do I have a problem with this database?

 

[mrdenny]

Does that table exist?

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog

 

[Ed75]

Yes, the table exists

 

[mrdenny]

Is there a space in the name or something that requires [] to be placed around the object name (which I'd recommend doing anyway)?

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog

 

[ptheriault]

wouldn't this be much easier?

sp_MSforeachtable @command1="UPDATE STATISTICS ? WITH FULLSCAN""

- Paul
- If at first you don't succeed, find out if the loser gets anything.