Results 1 to 3 of 3
  1. #1
    Join Date
    May 2002
    Posts
    395

    Unanswered: 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.

  2. #2
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    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.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  3. #3
    Join Date
    May 2002
    Posts
    395

    Re: Where and how to run sp_updatestats after upgrading

    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •