Finding experation date

• itmasterw 60042

  SSCrazy

  Points: 2858

  More actions

  January 16, 2020 at 6:53 pm

  #3716085

  Hi,

  We installed the SQL Server evaluation copy, and I am trying to find out when it will expire.

  Is there a way I can query the system to find this information?

  Thank you

• Sue_H

  SSC Guru

  Points: 90860

  More actions

  January 16, 2020 at 8:25 pm

  #3716123

  You use the undocumented extended stored procedure xp_qv. This post has a sample query to use:

  When will my SQL Server Evaluation Edition expire?

  Sue

• Jeff Moden

  SSC Guru

  Points: 1004323

  More actions

  January 16, 2020 at 9:09 pm

  #3716140

  As a bit of a sidebar, why not just use the Developer's Edition for evals?  So long as you never use the Developers Edition for production, it's legal.

  --Jeff Moden

  ---

  RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
  First step towards the paradigm shift of writing Set Based code:
  ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

  Change is inevitable... Change for the better is not.
  

  ---

  Helpful Links:
  How to post code problems
  How to Post Performance Problems
  Create a Tally Function (fnTally)
  

• itmasterw 60042

  SSCrazy

  Points: 2858

  More actions

  January 17, 2020 at 1:28 pm

  #3716282

  Hi,

  Thanks that did it.

   

  Thank you