none
Object Explorer Details - cant search on all database

    Question

  • Hi,

    When I'm searching for a word in the search pane in Object Explorer Details

    I can't get any result if I select the database node, only if I select a specific database.

    Thanks.

    Wednesday, June 13, 2012 10:17 AM

Answers

  • Yes - Redgate has been around for a long time and is regarded as a good company.  Their search tool has the additional benefit of being able to search for text inside stored procedures/functions/etc

    Chuck Pedretti | Magenic – North Region | magenic.com

    Wednesday, June 13, 2012 3:07 PM

All replies

  • Hello,

    Which "Search pane" do you mean? Have you installed a special SSMS addin?


    Olaf Helper
    * cogito ergo sum * errare humanum est * quote erat demonstrandum *
    Wenn ich denke, ist das ein Fehler und das beweise ich täglich
    Blog Xing


    Wednesday, June 13, 2012 10:26 AM
  • No, this is the one: http://www.mssqltips.com/tipImages2/1935_image004.png

    Wednesday, June 13, 2012 10:38 AM
  • Maybe you don't have permissions to the other databases?  I just tried it in SSMS 2012 and SSMS 2008 and it worked fine.  If you want to be able to search accross all databases with a tool that works better then I would suggest installing SQL Search:

    http://www.red-gate.com/products/sql-development/sql-search/


    Chuck Pedretti | Magenic – North Region | magenic.com



    Wednesday, June 13, 2012 12:48 PM
  • OK, thanks!

    is it safe to use this tool?

    Wednesday, June 13, 2012 1:26 PM
  • Yes - Redgate has been around for a long time and is regarded as a good company.  Their search tool has the additional benefit of being able to search for text inside stored procedures/functions/etc

    Chuck Pedretti | Magenic – North Region | magenic.com

    Wednesday, June 13, 2012 3:07 PM