Today I will explain how to find out which service pack is installed on Instance.In windows if you install service pack you can find out easily by seeing add/remove programs or by seeing my computer properties but for SQL server there is a little tip is there.You cannot see in add/remove programs.
Finding Service Pack :
TIP 1: select serverproperty ('productlevel') by using the above statement you can find out which service pack is installed.I have two instances in single computer.One is having Default Instance and other is Named Instance.I already Installed service pack 3 on Default Instance and there is no service pack for Named Instance.
Below two pictures are there to find out the difference,
Note : RTM stands for Release To Manufacturing.
One more method is also there without running the T-SQL statement.
TIP 2 :
When you connect the Instance by using object explorer, the object explorer will show you how many Instances are connected.
Just right click on the particular Instance and select new query.
If there is no service pack installed it will show as RTM
No comments:
Post a Comment