RE: where and how to run sp_updatestats after upgrading

Hi,
I have a question on where and how to run sp_updatestats after upgrading databases from SQL Server 7.0.
Thanks for your reply.After the successful upgrade from QUery analayzer use the database and run SP_UPDATESTATS to update stats on all the tables or you can run DBCC DBREINDEX for optimum performance.|||Hi Satya,

Thanks for your reply.

Do I need to run sp_updatestats for each database in order to updae stats for all the tables in the Query Analyzer? How does DBCC DBREINDEX works?

Thanks!
Alice