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
how to restore files with rman?
What are the commands used in dcl? : sql server DBA
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
Explain about your sql server dba experience? : sql server DBA
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
How to start SQL Server in minimal configuration mode?
What authentication modes does sql server support? : sql server DBA
Query processing is slow(eg select query)how will u solve that
What are the operating modes in which database mirroring runs? : sql server DBA
Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit
Why does Oracle not permit the use of PCTUSED with indexes?
What is the difference between clustered and non-clustered index? : sql server DBA
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
What the different types of replication and why are they used? : sql server DBA
What are the different types of database compression introduced in sql server 2008? : sql server DBA