Friday, July 8, 2011

How to determine currently using SQL version or edition

To determine the version of SQL Server, you can use any of the Step 2 or Step 3:-


Step1:- Open an Sql instance and connect


step2:- Execute an query   Select @@version debug and run


step3:-  To know about Productversion, Product level and edition execute this below Query.
SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')

PowerShell script to delete file versions from the specified SharePoint document library

Managing file versions in SharePoint Online is essential to maintain storage hygiene and performance, especially when versioning is enabled ...