SQL to Check SQL Server is VL upgrade compatible

This forum allows developers to post programming tips and coding techniques that may be useful to other Visual LANSA developers. The information contained in this forum has not been validated by LANSA and, as such, LANSA cannot guarantee the accuracy of the information.
Post Reply
PatrickF
Posts: 8
Joined: Thu Nov 26, 2015 1:31 pm

SQL to Check SQL Server is VL upgrade compatible

Post by PatrickF » Thu Nov 26, 2015 1:42 pm

When checking your VL install prior to upgrading an older version, you should check that your local SQL Server Express install can be upgraded. Unfortunately, SQL Management Studio and Add Remove Programs will show an SQL Version as a version number (eg SQL Server 10.0.5538.0) rather than the Text Version "Microsoft SQL Server 2008 (SP3) Express Edition (64-bit) SP3". Below is an SQL Query you can use in SQL Server Management Studio to get a user readable version. Use the New Query button in Management Studio and paste this query:

SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition'), @@servername 'Server Name',
substring(@@version,1,charindex('-',@@version)-1)
+convert(varchar(100),SERVERPROPERTY('edition'))+ ' '+
+convert(varchar(100),SERVERPROPERTY('productlevel'))'Server Version'

Post Reply