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
who owns the operating system files created by the utl_file package?
What is transparent data encryption? : sql server DBA
How would you go about verifying the network name that the local_listener is currently using?
What the different topologies in which replication can be configured? : sql server DBA
Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com
when does an alert gets signaled?
how does an oracle clusterware manage crs resources?
What happens on checkpoint? : sql server DBA
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
what is ora 24313?what is the procedure to exclude that error?
what is the last version,the release date of that version and fix pack of ibm db2 udb?
how to restore files with rman?
How do you trace the traffic hitting a sql server? : sql server DBA
What are the different types of upgrades that can be performed in sql server? : sql server DBA
What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA