Post reply

service pack version

  • December 18, 2003 at 7:33 am

    #64892

    Hi,

    How can i know the version of Service pack that is installed on Sql Server 7. using a command on Query Analyzer.

    TIA

  • December 18, 2003 at 8:25 am

    #486958

    Do a "select @@version" and check the build number check this against a table on the link below . Or look at the top of the latest SQL errorlog file. Or do a file

    properties on the sqlservr.exe file. All should return the same value

    http://vyaskn.tripod.com/sqlsps.htm

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

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