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

What is the importance of a recovery model? : sql server DBA

789


What the different types of replication and why are they used? : sql server DBA

875


how can you implement fine-grained auditing?

846


What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?

2432


What are the different ways you can create databases in sql server? : sql server DBA

828


How can you control the amount of free space in your index pages? : sql server DBA

1015


when we login sql editor using username and password then it says this error "could not resolve service name" then what can we do at client side.( here thing is tnsnames.ora file is ok till yesterday and worked well, but now it giving error.

1450


Why does Oracle not permit the use of PCTUSED with indexes?

2621


how can you get actual data change values from previous transactions in oracle?

830


how to restore files with rman?

1978


how can you generate profile of pl/sql applications to identify performance bottlenecks?

825


What is dcl? : sql server DBA

906


Can you redefine a table online?

888


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?

2271


What are the recovery models for a database? : sql server DBA

835