Does SQl 2005 have an Object Search feature like QA (2000) does?

  • One of the features I loved about QA (Query Analyzer) in SQL 2000 was the Object Search screen.  I am unable to find anything in SQL 2005 that is equivalent to the Object Search.  Anyone know if there is an Object Search in 2005?  I would be shocked to see something as useful as this end up not being a part of 2005 and so I’m assuming there is just an option or menu item somewhere that is not part of the default setup that brings up the Object Search screen.  Then again maybe I’m wrong and this is no longer in SQL.  Any ideas?

     

    Thanks

    Ed

    Kindest Regards,

    Just say No to Facebook!
  • This was removed by the editor as SPAM

  • select * from sys.objects ( an alternative Transact SQL)

  • What I've found is that while there doesn't seem to be the corresponding app in sql 2005, and aside from writing t-sql querying the sysobjects table, you can still connect to sql 2005 databases using the old query analyzer and thus still use it's built in object search (you are prompted to install a sp - sp_MSObjsearch though which is what the object search calls to carry out the actual search).

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply