How to determine the service pack currently installed on SQL Server

Home >> Dot Net Interview Questions >> Mix Dot Net Questions

Posted on May 18th , 2009 by Admin

	The global variable @@Version stores the build number of the sqlservr.exe, which is used to determine the service pack installed. eg: Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05 Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition on Windows NT 5.0 (Build 2195: Service Pack 3)