SQL Server Performance

Should service packs be installed on client ?

Discussion in 'General DBA Questions' started by NewDBA, Sep 16, 2003.

  1. NewDBA New Member

    I don't have a sql server installed on my workstation just client tools.
    I thought i don't have to install service packs?
  2. gaurav_bindlish New Member

    Well the vulnerrabilities exposed by MDAC are fixed in the service pack. Also there may be some chnages in the SQL tools behavior. So you need to install service pack on client machines as well.

    Gaurav
    Moderator
    Man thrives, oddly enough, only in the presence of a challenging environment- L. Ron Hubbard
  3. NewDBA New Member

    how then to find out which service pack is instaled on client?
  4. gaurav_bindlish New Member

    Probably looking at the version of DLL's present. I have no details about this. Probably we should wait until Satya comes back from hibernation.

    Gaurav
    Moderator
    Man thrives, oddly enough, only in the presence of a challenging environment- L. Ron Hubbard
  5. royv New Member

    http://www.sqlteam.com/item.asp?ItemID=8318


    "How do you expect to beat me when I am forever?"
  6. Luis Martin Moderator

    In EM "About Microsoft Manager Control" you find information about SP.

    May be Satya is fishing.....

    Luis Martin
  7. gaurav_bindlish New Member

    Royv, NewDBA is talking about SP on client machine.

    Gaurav
    Moderator
    Man thrives, oddly enough, only in the presence of a challenging environment- L. Ron Hubbard
  8. NewDBA New Member

    it's not funny anymore:network guys suspect that my box been infected
  9. gaurav_bindlish New Member

    I would say, Prevention is better than cure. However, I have forwarded you the link in other post about the tool to scan for infection. Use the same to verify.

    Gaurav
    Moderator
    Man thrives, oddly enough, only in the presence of a challenging environment- L. Ron Hubbard
  10. royv New Member

    Sorry about that gaurav_bindlish, I misread.


    "How do you expect to beat me when I am forever?"
  11. NewDBA New Member

    Thank you
    Also am not very sure which sp should i apply for:

    SQL Server 2000 Desktop Engine(MSDE)
    or
    Database Components?
  12. gaurav_bindlish New Member

    I think Database Components as you don't have MSDE installed on your machine.

    Wait a minute.. I think there will be an option while installing the service pack.

    Gaurav
    Moderator
    Man thrives, oddly enough, only in the presence of a challenging environment- L. Ron Hubbard
  13. NewDBA New Member

    No there are no options
    So for server -SQL Server 2000 Desktop Engine(MSDE)
    for client-database components?
  14. gaurav_bindlish New Member

    For server as well as clients - Database components.

    Gaurav
    Moderator
    Man thrives, oddly enough, only in the presence of a challenging environment- L. Ron Hubbard
  15. NewDBA New Member

    Is SQL Server 2000 Desktop Engine different product?
  16. gaurav_bindlish New Member

    That is MSDE.

    Gaurav
    Moderator
    Man thrives, oddly enough, only in the presence of a challenging environment- L. Ron Hubbard
  17. NewDBA New Member

    I guess the question then will be:
    how to install MSDE?
    in sql server cd->>sql server components i have only:
    Install Database server
    install analysis services
    install english query
  18. gaurav_bindlish New Member

  19. satya Moderator

    Anyway when you try to install SP on the client machine it automatically detects and applies required patches.

    _________
    Satya SKJ
    Moderator
    SQL-Server-Performance.Com
  20. Luis Martin Moderator

    Well, Satya is no fishing at all...

    Allways is apropiate to have last SP on Workstations or Serves.

    Luis Martin
  21. NewDBA New Member

    Thank you all very much

Share This Page