Interested to Buy Any Domain ? << Click Here >> for more details...
How to determine the service pack currently installed on
SQL Server?
- 1 Answers
- 4442 Views
- I also Faced
- E-Mail Answers
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 is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
how can you get actual data change values from previous transactions in oracle?
Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down? : sql server DBA
What are the recovery models for a database? : 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 is a system database and what is a user database? : sql server DBA
what is asm?
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?
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
What is the default fill factor value? : sql server DBA
What are the different ways you can create databases in sql server? : sql server DBA
What the different types of replication and why are they used? : sql server DBA
How can you control the amount of free space in your index pages? : sql server DBA
What is dcl? : sql server DBA
how can you process messages in order asynchronously?
