Current SQL Server servicepack on passivenode

• krnkmr084

  SSC Enthusiast

  Points: 106

  More actions

  February 24, 2013 at 10:08 pm

  #271337

  Hi All,

  Is there any way to find out sql server service pack level on passivenode, on active node sp2 hasbeen installed i need to find out servicepack without failingover to currentpassivenode.

  Thanks

  Kiran

• BuntyBoy

  SSCommitted

  Points: 1876

  More actions

  March 5, 2013 at 12:37 pm

  #1593612

  Go to SQL Server Configuration Manager --> SQL Server Service --> Right click --> properties --> Advanced tab --> scroll down to version...

  ===========================================
  Better try and fail than not to try at all...

  Database Best Practices[/url]

  SQL Server Best Practices[/url]