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
i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?
what is a crs resource?
how does an oracle clusterware manage crs resources?
What is the default port no on which sql server listens? : sql server DBA
What types of replication are supported in sql server? : sql server DBA
what is grd?
Where would you look for errors from the database engine?
What is transparent data encryption? : sql server DBA
What are statistics, under what circumstances they go out of date, how do you update them?
How do you trace the traffic hitting a sql server? : sql server DBA
What the different topologies in which replication can be configured? : sql server DBA
What are the commands you'd issue to show the explain plan for "select * from dual"?
what are the benefits of flashback feature?
how can a session indicate its interest in receiving alerts?
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?