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

 Posted by Bharathi Cherukuri on 4/25/2012 | Category: Sql Server Interview questions | Views: 1532 | Points: 40

The global variable @@Version stores the build number of the sqlservr.exe.
This is the way which is used to determine whether the service pack is installed or not.

Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response