Way to retrieve SQL server version information

Do you want to get the extract version of the SQL server you have installed in your machine with the service packs? Try this on query window.
SELECT @@VERSION

or for SQL Server 2000 and above the following is easier to parse
SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY('productlevel'), SERVERPROPERTY('edition')
Cheers.

Popular posts from this blog

How to get SharePoint dll version using JavaScript quickly

If you are working on SharePoint apps development you will need to know the SharePoint dll version to put webparts in to the page. In webparts we need to provide the SharePoint dll version in the  '  In this sinario you can use following service url and make a quick call and get the version of the SharePoint dll on Office 365 SharePoint Online as well as SharePoint Onprem. /_vti_pvt/buildversion.cnf SharePoint On Premise output vti_encoding:SR|utf8-nl vti_buildversion:SR|15.0.4737.1000 SharePoint Online Office 365 output as of 04/07/2017 vti_encoding:SR|utf8-nl vti_buildversion:SR|16.0.6621.1204 Function for get the version no.     getSharePointVersion: function () {         var ver = null;         $.ajax({             url: "/_vti_pvt/buildversion.cnf",             async: false,         }).done(function (result) {             var lines = result.trim().split('\n');             if (lines.length == 2) {                 var versionProperty = li
Read more

SharePoint App Only Registration Key Renewal script

################################## ## Checking secret working ################################## $clientSecret = 'xxxxx' Connect-PnPOnline -Url "https://xxxx.sharepoint.com/sites/DevSite" -ClientId 67c86709-5348-45b9-a16b-9b7a983a20c2 -ClientSecret $clientSecret Get-PnPConnection Get-PnPListItem -List LookupList ################################### ## Get all Keys #################################### $msolcred = get-credential connect-msolservice -credential $msolcred $clientId = "67c86709-5348-45b9-a16b-9b7a983a20c2" $keys = Get-MsolServicePrincipalCredential -AppPrincipalId $clientId $keys ################################## ## Remove keys ################################## Remove-MsolServicePrincipalCredential -KeyIds $keys.KeyId -AppPrincipalId $clientId ######################################## ## Generate key for 3 years ######################################## $bytes = New-Object Byte[] 32 $rand = [System.Security.Cryptography.RandomNumberGenerator]::Cre
Read more