Skip to content

Instantly share code, notes, and snippets.

@mvillegascuellar

mvillegascuellar/sql_trial_query_remaining_days.sql

Last active October 3, 2018 22:11
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save mvillegascuellar/8c5b3aadc186a4e88a901e91acffa3eb to your computer and use it in GitHub Desktop.
Save mvillegascuellar/8c5b3aadc186a4e88a901e91acffa3eb to your computer and use it in GitHub Desktop.
Download ZIP
Raw
sql_trial_query_remaining_days.sql
EXEC sp_configure 'show advanced options', 1;
GO
RECONFIGURE
GO
EXEC sp_configure 'Agent XPs', 1;
GO
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
-- referencia: https://blogs.msdn.microsoft.com/sqlosteam/2013/02/17/when-will-my-sql-server-evaluation-edition-expire/
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment