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')

Update or edit status filed in JIRA issue

the status field is a special case and can't be updated directly, which is the second problem here. Changing a status in Jira is called ...