Post reply

Version

  • October 9, 2013 at 8:48 am

    #395634

    Hi, I'm just trying to verify if I have a CTP version of SQL 2008 R2.

    @@version gives me:

    Microsoft SQL Server 2008 R2 (SP2) - 10.50.4000.0 (X64) Jun 28 2012 08:36:30 Copyright (c) Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)

    SERVERPROPERTY('ProductLevel') gives me SP2 only.

    I suspect I'm not looking in somewhere really obvious!!

    'Only he who wanders finds new paths'

  • October 9, 2013 at 9:13 am

    #1657204

    If it was CTP it would say CTP in @@version.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • October 9, 2013 at 9:29 am

    #1657207

    Thanks Gail, that's what I thought.

    For some reason though Idera is saying its SP2 CTP and unsupported!

    David

    'Only he who wanders finds new paths'

  • October 9, 2013 at 9:48 am

    #1657214

    Ask them how they know that.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • October 9, 2013 at 9:53 am

    #1657219

    Well, their monitoring software but yes, that's my next call!

    Thanks again Gail!!

    'Only he who wanders finds new paths'

  • October 10, 2013 at 11:17 am

    #1657656

    david.alcock (10/9/2013)

    Thanks Gail, that's what I thought.

    For some reason though Idera is saying its SP2 CTP and unsupported!

    David

    Idera's Patch Analyzer has a link "Check for New List", which does what you'd expect on request but not automatically.

    Mike Hinds Lead Database Administrator1st Source BankMCP, MCTS

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply