Interested to Buy Any Domain ? << Click Here >> for more details...
How to determine the service pack currently installed on
SQL Server?
- 1 Answers
- 4447 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 use of ocr?
Explain about your sql server dba experience? : sql server DBA
In what script is "snap$" created? In what script is the "scott/tiger" schema created?
how can you find out if a table can be redefined?
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
What is a correlated sub-query? : sql server DBA
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.
what is grd?
When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA
What is the importance of a recovery model? : sql server DBA
what is the diffrence between core dba and apps dba?
Why would you call update statistics? : sql server DBA
What would you do with an "in-doubt" distributed transaction?
how can you communicate with operating system files from oracle?
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
