How to determine the service pack currently installed on SQL Server?

 Posted by Chikul on 12/22/2009 | Category: Sql Server Interview questions | Views: 4096

The global variable @@Version is used to determine the service pack installed.
Ex : SELECT @@Version
O/P : Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86) Oct 14 2005 00:33:37 Copyright (c) 1988-2005 Microsoft Corporation Developer Edition on Windows NT 5.2 (Build 3790: Service Pack 2)

Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response