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’)