Installing of service pack

  • after download of sp3A i execute its exe ,but in query analyzer it shows no sp

    there is another way of registe it?

    Pls suggest

  • Did it install with no errors?

    Steve Jones

    sjones@sqlservercentral.com

    http://www.sqlservercentral.com/columnists/sjones

    The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/

    http://www.dkranch.net

  • Just in case ...

    Casting my mind back to the SP3 install, where the first exe you run just unzips files (and doesn't actually do the install).

    Look for a setup.bat or a setupsql.exe and run that.

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

  • I did the same on a trial edition and the version did not change.

    Sp3a is "supposed" to be able to update trial editions but this did not .

    I had no error messages..

    Mike

  • You say in QA... You mean when you run @@version is doesnt show 8.00.760 as the version of MSSQL2K?

    You can check for the change date of SYSPROCESSES table in the master database. The SP should update this table with a new create date after the SP is run.

    -Isaiah


    -Isaiah

  • I forgot you had to look at the extracted file(executable) and run it

    All worked fine

    Mike

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

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