A few of our customers are on a Evaluation version of SQL server, this query will allow you to see how many days left that SQL server has before the Evaluation version Expires.

None. This is a selection query and no data is modified in the running of it.

sp_configure 'show advanced options', 1;

RECONFIGURE

GO

sp_configure 'Agent XPs', 1;

RECONFIGURE

GO

DECLARE @daysleft int

DECLARE @instancename sysname

SELECT @instancename = CONVERT(sysname, SERVERPROPERTY('InstanceName'))

EXEC @daysleft = xp_qv '2715127595', @instancename

SELECT @daysleft 'Number of days left'

GO

Will look similar to this:

• Entered : 5/20/2015 David Kingsbury
• Version : Will work on all Versions of SQL