How to determine the service pack currently installed on SQL Server ?
Interview question and answer by: Bharathi Cherukuri
| Posted on: 4/25/2012 | Category: SQL Server Interview questions
| Views: 470 | | 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.
| Alert Moderator
Found interesting? Add this to: