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
how can you find out if a table can be redefined?
how can you schedule a job in database?
what is ora 24313?what is the procedure to exclude that error?
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 happens on checkpoint? : sql server DBA
What purpose does the model database server? : sql server DBA
Why would you use sql agent? : sql server DBA
What is dcl? : sql server DBA
What is the difference between dropping a database and taking a database offline? : sql server DBA
who owns the operating system files created by the utl_file package?
when does an alert gets signaled?
how can you enable flashback feature?
what is the use of recording information about current session?
Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA
How can you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?