Interested to Buy Any Domain ? << Click Here >> for more details...
How to determine the service pack currently installed on
SQL Server?
- 1 Answers
- 4340 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
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
Why does Oracle not permit the use of PCTUSED with indexes?
In what script is "snap$" created? In what script is the "scott/tiger" schema created?
What are the commands used in dcl? : sql server DBA
How to start SQL Server in minimal configuration mode?
what is a crs resource?
How do you open a cluster administrator? : sql server DBA
how to restore files with rman?
Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA
What is the difference between dropping a database and taking a database offline? : sql server DBA
What authentication modes does sql server support? : sql server DBA
How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA
internal architecture
what are the benefits of flashback feature?
what is grd?
