• Are you familiar with the view sys.all_objects? That'll give you a list of all tables, views, procs, etc., in the database. Should be able to find what you're looking for in there.

    If you do a clean SQL Server install, either as a separate instance or on a separate computer, you can narrow the search down by doing an Except query vs that copy of master. You can also look at the types, but it's easy to miss something that way.

    Would look something like:

    select name

    from master.sys.all_objects

    except

    select name

    from MySecondServer.master.sys.all_objects;

    That'll give you a good starting point.

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon