Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
Object Explorer Details - cant search on all database

Answered Object Explorer Details - cant search on all database

  • Wednesday, June 13, 2012 10:17 AM
     
     
    Sign In to Vote
    0

    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.

     

All Replies

  • Wednesday, June 13, 2012 10:26 AM
     
     
    Sign In to Vote
    0

    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:38 AM
     
     
    Sign In to Vote
    0

    No, this is the one: http://www.mssqltips.com/tipImages2/1935_image004.png

     
  • Wednesday, June 13, 2012 12:48 PM
     
     
    Sign In to Vote
    0

    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 1:26 PM
     
     
    Sign In to Vote
    0

    OK, thanks!

    is it safe to use this tool?

     
  • Wednesday, June 13, 2012 3:07 PM
     
     Answered
    Sign In to Vote
    0
    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