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

Answer Posted / guest

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)

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

how can you find out if a table can be redefined?

823


how can you schedule a job in database?

851


what is ora 24313?what is the procedure to exclude that error?

2363


You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?

4228


What happens on checkpoint? : sql server DBA

823


What purpose does the model database server? : sql server DBA

867


Why would you use sql agent? : sql server DBA

813


What is dcl? : sql server DBA

933


What is the difference between dropping a database and taking a database offline? : sql server DBA

850


who owns the operating system files created by the utl_file package?

848


when does an alert gets signaled?

811


how can you enable flashback feature?

745


what is the use of recording information about current session?

832


Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA

861


How can you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?

2298