What Service Pack is a loaded?

• kwitzell

  SSCrazy

  Points: 2470

  More actions

  April 10, 2006 at 1:33 pm

  #112486

  Is there a way to determine which service pack level a SQLServer instance is on? thanks

  Ken

• Jo Pattyn

  SSC-Dedicated

  Points: 32347

  More actions

  April 10, 2006 at 1:47 pm

  #631826

  select @@version

  According to the books online the xp_msver stored procedure gives more information

• sushila

  SSC-Dedicated

  Points: 35293

  More actions

  April 10, 2006 at 1:50 pm

  #631827

  another link

  
  
  
  
  
  
  **ASCII stupid question, get a stupid ANSI !!!**

• kwitzell

  SSCrazy

  Points: 2470

  More actions

  April 11, 2006 at 3:59 pm

  #631967

  Thank you all for your help!

  Ken