How To Know SQL Server Service Pack In Your Machine

Hi Guys in this tutorial i will explain you How To Know SQL Server Service Pack In Your Machine.If you’re running SQL Server, it’s wise to keep latest service pack installed for optimum performance. If you’re not sure about service pack (or if you’re still running RTM), then follow these steps to find out:

1. Open SQL Server management studio.

2. Click on New query Label at Top left Side.

3. Use this Query:

SELECT SERVERPROPERTY(‘productversion’)as VersionNumber,SERVERPROPERTY(‘productlevel’)as Productlevel,SERVERPROPERTY(‘edition’)as Edition

4. Now click execute or F5.

Then you will get result of the above query and your are done.