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

Posted by Chikul on 12/22/2009 | Category: Sql Server Interview questions | Views: 4624

Post |

Interview FAQs |

Exclusive Questions |

Interview Home

Answer:

The global variable @@Version is used to determine the service pack installed.
Ex : SELECT @@Version
O/P : Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86) Oct 14 2005 00:33:37 Copyright (c) 1988-2005 Microsoft Corporation Developer Edition on Windows NT 5.2 (Build 3790: Service Pack 2)

Asked In: Many Interviews | Alert Moderator