Changing default database in SQL Query Analyzer

• Vic Rauch-303403

  SSCommitted

  Points: 1576

  More actions

  October 23, 2007 at 10:25 am

  #153911

  Is there some way, and if so, what is it, to change the default database from master to a database of my choice when I open Query Analyzer? That is, something besides using the dropdown after QA opens.

  [font="Comic Sans MS"]Vic[/font]
  www.vicrauch.com

• Sql Junkie-204042

  Hall of Fame

  Points: 3874

  More actions

  October 23, 2007 at 10:36 am

  #744626

  Look up sp_defaultdb in BOL. Basic syntax is

  sp_defaultdb [ @loginame = ] 'login', [ @defdb = ] 'database'

• Vic Rauch-303403

  SSCommitted

  Points: 1576

  More actions

  October 23, 2007 at 10:58 am

  #744630

  Thank you!!!!!

  Worked great!

  [font="Comic Sans MS"]Vic[/font]
  www.vicrauch.com