跳转至主内容

 none
如何查看sql server的剩余剩余使用时间,一台是sql server 2008 R2 一台是2016 RRS feed

全部回复

  • 请问你使用是评估版吗

    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com

    2019年10月8日 1:46
  • 不清楚 ,刚接手 想看看到底是什么版本的
    2019年10月8日 3:43
  • Hi 老猫回春,

     

    请执行select @@version,查看当前sql server 是什么版本。 不是评估版的话,你就可以一直使用,只是sql server 2008 r2已经不受微软支持,建议你升级成更高版本。

     

    如果是评估版建议你使用下面代码查看sql server的剩余使用时间

     

    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

     

    Best regards,

    Dedmon Dai


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com

    2019年10月8日 6:10
  • 有一个是评估版2008R2 请问实在维护里面更新序列号么
    2019年10月9日 0:59
  • 是的,在维护计划里面有个版本升级:


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com

    2019年10月9日 1:09