• If the object IDs haven't changed between SQL 2005 and SQL 2008, the system procedure is sp_MSenumchangesdirect (not that it helps much)

    Let's rather focus on the two objects in database 7, can you get the names of the tables and procedures? The objectID for the procedures is in the two inputbuf lines, the partitionID is listed as part of the KEY: (the part after the 7:), you can then join that to sys.indexes to get table and index names.

    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