Determine which SP version or number is loaded

• l0n3i200n

  Ten Centuries

  Points: 1091

  More actions

  April 20, 2007 at 12:04 am

  #175929

  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

• Grant Fritchey

  SSC Guru

  Points: 398886

  More actions

  April 20, 2007 at 10:48 am

  #701777

  Check this knowledge base article on MSDN:

  http://support.microsoft.com/kb/321185

  SELECT  SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')

  "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
  - Theodore Roosevelt

  Author of:
  SQL Server Execution Plans
  SQL Server Query Performance Tuning