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

List out some of the requirements to setup a sql server failover cluster.? : sql server DBA

0 Answers  


which background process invoke at the time of upgradation tell me???

0 Answers   iGate,


What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA

0 Answers  


What the different topologies in which replication can be configured? : sql server DBA

0 Answers  


i need a brief information about db2 dba course and realtime experts if any plz inform me nareshbhupathi93@gmail.com plzzz urgent

1 Answers   TCS,






What are the ways tablespaces can be managed and how do they differ?

2 Answers   IBM,


can u plz tell me what r the mandatory skills for getting job as a sql dba......plz send me all details thank you my id :k.mohann.mohan@gmail.com

0 Answers  


Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA

0 Answers  


what is ora 600?

1 Answers  


what is a crs resource?

0 Answers   Oracle,


i had backup last manday.now i need back monday to now ..how do get backup?

3 Answers   Infozech, Wipro,


What SQL query from v$session can you run to show how many sessions are logged in as a particular user account?

3 Answers  


Categories