Post reply

select @@version didn't return (SP2) after sql 2012 sp2 is applied

  • June 23, 2014 at 9:56 am

    #308476

    Normally after we apply sql service pack, we run 'select @@version' and it will show 'SP1', 'SP2'... in the result set. I notice for SQL 2012 SP2, after I apply sp2, it only shows the build version '11.0.5058.0' but not 'SP2' is specified. I assume this is normal for SQL 2012 SP2?

    Thanks,

    Maggie

  • June 23, 2014 at 11:05 am

    #1724143

    I have checked a few instances that are SQL Server 2012 SP2 and the all have the same result from @@VERSION. 11.0.5058.0 is the correct version number for sp2. You can also check the server property for the service pack level

    select SERVERPROPERTY('Productlevel')

    Bob
    -----------------------------------------------------------------------------
    How to post to get the best help[/url]

Viewing 2 posts - 1 through 2 (of 2 total)

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