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

Posted by Bharathi Cherukuri on 4/25/2012 | Category: Sql Server Interview questions | Views: 2683 | Points: 40

Post |

Interview FAQs |

Exclusive Questions |

Interview Home

Answer:

The global variable @@Version stores the build number of the sqlservr.exe.
This is the way which is used to determine whether the service pack is installed or not.

Asked In: Many Interviews | Alert Moderator

Bookmark It

< Previous : What is an application domain ?

Next > : What is RAID and what are different types of RAID ...

Comments or Responses

More Interview Questions by Bharathi Cherukuri

What is RAID and what are different types of RAID configurations ?
We have an employee salary table, how do we find the second highest fr ...
What is Snow Flake Schema design in database ? What’s the difference b ...
What are Data Marts ?
Why strings are immutable ?
What is Data Provider ?
What is the use of Parameter Object ?
What is the difference between OLEDB Provider and SqlClient ?

Latest Interview Questions

Web service can only be written in .net?
Where on the Internet would you look for Web services?
How do you turn off cookies for one page in your site?
What is Machine.config?
What is Global Asssembly Cache (GAC)?
What is Page Inspector in VS 2011 ?
What is a Web Service?
What is CTS?
More ...