SSMS 2017 v17.9 to register an instance of SQL Server 2008 Express Edition

• Express12

  SSCoach

  Points: 18514

  More actions

  October 17, 2018 at 1:58 pm

  #381247

  Is it possible to register an instance of SQL Server 2008 Express in my current SSMS 2017 v17.9 tool?

  If not, how can I view databases and tables in an instance of SQL Server 2008 Express?  Do I need to install a version of SSMS for 2008?

  (I've been tasked w/ upgrading an instance of SQL 2008 Express to SQL 2017 Express)

  BT

• Thom A

  SSC Guru

  Points: 99130

  More actions

  October 17, 2018 at 2:02 pm

  #2010144

  SSMS 2017 (and 2019 preview) support all supported version of SQL Server, which (for now, but not for much longer) includes SQL Server 2008.

  Thom~

  Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
  Larnu.uk

• Michael L John

  One Orange Chip

  Points: 27055

  More actions

  October 17, 2018 at 2:11 pm

  #2010147

  I have SQL running from 2005 to 2017 and everything in between.
  It works fine on all versions, except for SQL Agent in 2005.

  Michael L John
  If you assassinate a DBA, would you pull a trigger?
  To properly post on a forum:
  http://www.sqlservercentral.com/articles/61537/