Problem with updating statistics

[Ed75]

I am using the following script to update the stats on my dataabses

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 one database I am getting an error stating that the table does not exist. The table does indeed exist and if I omit that table from my script it goes to the next line of the sysobjects table and then tells me that the next table does not exist.

Any Ideas?
Thanks,
Ed

 

[SQLDenis]

obviously you need brackets around the tablename, you might have spaces or something like that

change this

SELECT name
FROM sysobjects

to this

SELECT quotename(name)
FROM sysobjects

and try again

Denis The SQL Menace
--------------------
SQL Server Code,Tips and Tricks, Performance Tuning
SQL Server Programming Hacks

 

[Ed75]

Exact same error, good thought though

 

[SQLDenis]

what do you see when you print the SQL?

Denis The SQL Menace
--------------------
SQL Server Code,Tips and Tricks, Performance Tuning
SQL Server Programming Hacks