Throwing this post out here more for myself than anything. The following query will determine what Service Pack your SQL 2005 server is running.

SELECT  SERVERPROPERTY(‘productversion’), SERVERPROPERTY (‘productlevel’), SERVERPROPERTY (‘edition’)

Advertisements