How to determine the service pack currently installed on
SQL Server?



How to determine the service pack currently installed on SQL Server?..

Answer / 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

More DB Administration Interview Questions

i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?

0 Answers   IBM,


Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.

0 Answers   Infosys,


How can you control the amount of free space in your index pages? : sql server DBA

0 Answers  


In what script is "snap$" created? In what script is the "scott/tiger" schema created?

0 Answers  


What is fill factor? : sql server DBA

0 Answers  






what are the types of connection load-balancing?

0 Answers   Oracle,


How do you resize a data file?

2 Answers  


what is the difference between catalog & nocatalog?

3 Answers   CSC,


suppose you want to audit specific activities on sensitive data. How can you achieve that?

0 Answers   Oracle,


one datafile is lost in standy side how can you recover that??

2 Answers  


what is the difference between db2start command and start database manager command?

1 Answers  


How to bind a cobol module to a given job? I am not able to understand this concept.Can anyone help me out as how to carry out this task?

0 Answers   EDS,


Categories