service pack???

• Seemita Das

  SSC-Addicted

  Points: 455

  More actions

  January 20, 2006 at 5:44 am

  #89239

  How can I know what service pack the sql server is using???

  Can i do this using Query Analyser???

  I tried using '@@version' but it doesnt give the service pack info.

  please help

  regards,

  Seemita

• lucky-80472

  SSCertifiable

  Points: 7793

  More actions

  January 20, 2006 at 7:14 am

  #616059

  Hello Seemita,

  You can find out the details by using @@version in Query Analyzer as

  Select @@version

  which will give you information as

  Microsoft SQL Server  7.00 - 7.00.1063 (Intel X86) 

   bla bla bla

  Now based on the above information, go through this webpage to find the service pack that has been applied

  http://support.microsoft.com/default.aspx?scid=kb;en-us;q321185

  Hope this information is helpful to you.

  Thanks and have a nice day!!!

  
  Lucky

• SQLBill

  SSC Guru

  Points: 51440

  More actions

  January 20, 2006 at 7:50 am

  #616077

  I like querying for the SERVERPROPERTY.

  SELECT ServerProperty('Edition'),

  ServerProperty('ProductVersion'),

  ServerProperty('ProductLevel')

  Refer to the BOL, use the Index tab and enter SERVERPROPERTY for more information on this command.

  -SQLBill

• JeffJ

  Right there with Babe

  Points: 769

  More actions

  January 24, 2006 at 12:21 pm

  #616747

  Alternatively, use EM.  Right click the server instance, select Properties.  Look at "Product version" on the General Tab.

  ~Jeff