Post reply

SP4 logged ???

  • November 29, 2005 at 1:48 am

    #110391

    Morning everyone.

    Can anyone tell me where to look , and what to look for information on when a SQL server had SP4 applied ?

    Is there anything that would indicate a date and time to show this ?

    Many thannks everyone.

  • November 29, 2005 at 2:12 am

    #606337

    hi

    Version u can get from @@version

    8.00.760SQL Server 2000 SP3

    I think  8.00.2039  for Sp4  

     

    Regards

  • November 29, 2005 at 2:46 am

    #606353

    Hi Guys.

    Here is the complete Sql server version.

     

    @@versionVersion and Service Pack
    8.00.2039SQL Server 2000 with Service Pack 4
    8.00.760SQL Server 2000 with Service Pack 3a
    8.00.760SQL Server 2000 with Service Pack 3.
    8.00.532SQL Server 2000 with Service Pack 2
    8.00.384SQL Server 2000 with Service Pack 1
    8.00.194SQL Server 2000 with no service pack applied

     

    Cheers

  • November 29, 2005 at 2:57 am

    #606356

    You can also take a look at the log file created during SP4 setup, which is  %windir%\sqlsp6.log. It's very important for troubleshooting.

    Regards

  • November 29, 2005 at 6:02 am

    #606380

    Just a little addition to that list from Diego.  In order to distinguish between SP3 and SP3a (since the versions returned via @@version are the same for both), you can check the version for ssnetlib.dll.  It will be 2000.80.766 in the case of SP3a and 2000.80.760 in the case of SP3.

     

  • November 29, 2005 at 6:37 am

    #606388

    Thanks for the info rsharma.

    Have a nice day!

    Diego

     

  • November 29, 2005 at 6:42 am

    #606392

    Thanks everyone , some good tips there.

  • November 30, 2005 at 4:39 am

    #606666

    What might also be useful is SELECT SERVERPROPERTY('ProductVersion') ( Output results to text as opposed to grid in Query Analyser ). Hope this is of use. Rgds Derek

Viewing 8 posts - 1 through 7 (of 7 total)

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