Selection from object panel does not default to database in object panel

• tshad

  SSCertifiable

  Points: 5905

  More actions

  June 3, 2016 at 4:07 pm

  #327343

  One thing that drives me crazy is going to the object panel then database and after right-clicking on a table I do a "Select Top 1000 Rows". The database is then master - not the database the table is in. So then I find myself getting master over and over as I try to open other query windows from the current one.

  Is there a way to tell ssms to use database the table is in?

• Smendle

  Hall of Fame

  Points: 3969

  More actions

  June 4, 2016 at 10:44 am

  #1883259

  Single left click on the database in question to highlight it then do the right click and select TOP 1000 option.