Home Forums SQL Server 7,2000 Security Object Owner Changes to Database System Objects RE: Object Owner Changes to Database System Objects

  • July 1, 2010 at 11:10 am

    #1187811

    Direct updates should NEVER be done to the system tables. It's all too easy to break lots of things and not realise until far too late.

    When you have a little maintenance window, please run DBCC CheckCatalog on that database (CheckDB does not run CheckCatalog on sQL 2000). Make sure you don't have further lingering issues.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass