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
what functionality does oracle provide to secure sensitive information?
What is the difference between the 2 operating modes of database mirroring? : sql server DBA
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
What purpose does the model database server? : sql server DBA
how can you schedule a job in database?
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
What are the different types of indexes available in sql server? : sql server DBA
What is the importance of a recovery model? : sql server DBA
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
What are the operating modes in which database mirroring runs? : sql server DBA
how can you initialize log miner?
How would you go about verifying the network name that the local_listener is currently using?
What would you do with an "in-doubt" distributed transaction?
how can you get actual data change values from previous transactions in oracle?
how can you implement fine-grained auditing?