What are the challenges you face when working across database platforms? Take the survey

sql search doesn't default to all databases

Once upon a time, I searched on a selected database, since that time I cannot get the program to default back to all databases.  I have tried checking all databases manually or selecting the all databases at the top.  Neither stick.

Any ideas?


  • Options
    Ben_PBen_P Posts: 226 Silver 2
    Hi @CaptainNemo, thank you for your post. 

    If you have a database highlighted in Object Explorer or if you have an open query linked to a DB then SQL Search will default to the linked/highlighted DB. If you collapse the Object Explorer and have the SQL Server level highlighted then when you open SQL Search it will default to "All Databases". 
Sign In or Register to comment.