How to determine the service pack currently inst

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

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

The global variable @@Version stores the build number of the sqlservr.exe, which is used to determine the service pack installed. To know more about this process visit SQL Server service packs and versions.

(Continued on next question...)

Other Job Interview Questions

• What's SQL Server
• But what if you have to create a database with two filegroups, one on drive C and the other on drive D with log on drive E with an initial size of 600 MB and with a growth factor of 15%?
• How many layers of TCP/IP protocol combined of?
• Database design - What is denormalization and when would you go for it?
• What's the maximum size of a row?
• What is a traditional Network Library for SQL Servers?
• What are constraints? Explain different types of constraints.
• What's the maximum size of a row?
• What is a default TCP/IP socket assigned for SQL Server?
• Is SQL Server implemented as a service or an application?
• More...