Checking loaded service pack numbers or versions

• l0n3i200n

  Ten Centuries

  Points: 1091

  More actions

  April 20, 2007 at 12:03 am

  #370604

  Howdi

  I was wondering what is the easiest way of determening the Service Pack version loaded on the service using T-SQL or the IDE. I normally use @@Version. Any other suggestions?

  l0n3i200n

• Jayakumar Krishnan

  SSCarpal Tunnel

  Points: 4710

  More actions

  April 20, 2007 at 5:58 am

  #701689

  Hi,

  Can you check the below.

  master..xp_msver

  sp_server_info

  Jayakumar K.

  Thanks
  Jay
  http://www.sqldbops.com

• l0n3i200n

  Ten Centuries

  Points: 1091

  More actions

  April 20, 2007 at 6:18 am

  #701693

  Thanks for the reply. it work g8.

  l0n3i200n