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

Posted by

To view Verified answers click on the button below.

The global variable @@Version stores the build number of the sqlservr.exe, which is used
to determine the service pack installed. To know more about this process visit