Post reply

Difference in @@version and sp_server_info output

  • October 15, 2004 at 8:54 am

    #85686

    I have a W2K server with SQL2000 (SP3).  When I run 'select @@version' the output is:

    Microsoft SQL Server  2000 - 8.00.760 (Intel X86)   Dec 17 2002 14:22:05   Copyright (c) 1988-2003 Microsoft Corporation  Enterprise Edition on Windows NT 5.0 (Build 2195: Service Pack 4)

    When I run sp_server_info, the DBMS_VER value is:

    Microsoft SQL Server  2000 - 8.00.534 (Intel X86)   Nov 19 2001 13:23:50   Copyright (c) 1988-2000 Microsoft Corporation  Enterprise Edition on Windows NT 5.0 (Build 2195: Service Pack 2)

    Can someone explain why sp_server_info is not aware that the server and SQL2000 have been upgraded?

    Thanks!

    apf

  • October 15, 2004 at 10:01 am

    #526924

    This has been discussed several times in these forums and the consensus seems to be that sp_server_info selects from a system table that doesn't always get updated by hotfixes and even some service packs.  The preferred method for determining SQL Server version is 'select @@version'.

    Greg

    Greg

  • October 15, 2004 at 11:08 am

    #526931

    Thanks Greg.

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

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