Checking SQL server version

To check the SQL server Version ans service pack installed.

Run this query

Select @@version
SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'),
SERVERPROPERTY ('edition')



Comments

Post a Comment

Popular posts from this blog

Azure Stack

Azure Stack Azure Stack Development Kit (ASDK) Azure Stack Integrated Systems Azure Pack     Azure Stack &  Azure Stack Development Kit (ASDK) Azure Stack TP3 was the last distribution after which it has been renamed as Azure Stack Development Kit (ASDK)  This will remain single node and should be used for trying out Azure Stack.    Azure Stack Development Kit   https://azure.microsoft.com/en-gb/overview/azure-stack/development-kit-thank-you/       Azure Stack Integrated Systems The Azure Stack Integrated Systems are the ones that you buy from the OEM partners HP, Lenovo, Dell and soon to be Cisco, Avanade, and Huawei. And it's name has changed to   Azure Stack Integrated Systems .   Azure Stack integrated systems   https://azure.microsoft.com/en-us/overview/azure-stack/integrated-systems/       Azure Pack So what is WAP really ? Wind...
Read more

Lync 2013 to Skype For Business 2015 in-place upgrade

Lync 2013 to Skype For Business 2015 in-place upgrade     There are two options for In-Place upgrade:   Migrate-users mode (No user downtime):  Basically, this option is only available if organization has more than one Lync Server 2013 pool  (Don’t consider paired/secondary/backup pool)   Offline mode (Downtime require):  You can consider this option if the organization has only single pool or two pools in backup/paired pool configuration.    ·           No in-place upgrade with pool failover option Don’t use failover cmdlet to failover the primary pool to backup pool and start in-place upgrade in primary pool. This method is not supported. ·           Don’t start services in mixed mode while upgrading. ·           Don’t unpair the pools before completing upgrade process in ...
Read more