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

Installing Microsoft SharePoint Server 2013

Image
Yesterday we downloaded the newest preview version of Microsoft SharePoint 2013. Preview version is available in technet http://technet.microsoft.com/en-us/evalcenter/hh973397 . I configured a virtual machine with the preview version and following are the steps I followed to configure the SharePoint 2013. Prerequisites Installed OS – Microsoft Windows server 2008 R2 SP1 Installed Microsoft SQL Server 2008 R2 SP1 Find more information about the prerequisites from the link http://technet.microsoft.com/en-us/library/cc262485(office.15).aspx Downloaded SharePoint 2013 installer using link http://technet.microsoft.com/en-us/evalcenter/hh973397 Above link will download .img file named SharePointServer_en-us.img. I installed winrar and extracted the content inside the .img file to a separate folder. Installation steps Then I ran the installer and it gave following message. Which said I need to have couple of updates need to install in to the system. Microsoft has provided a tool...
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