SQL Server Performance

SQL service pack 3 instalation

Discussion in 'General DBA Questions' started by Anonymous, Jan 28, 2003.

  1. Anonymous New Member

    I plan to install sp3 on SQL server and wondering does it going to
    remove my current user permissions for tables etc.?
  2. bradmcgehee New Member

    No, installing SP3 won't affect your user's permissions. It should not affect any of your SQL Server or database settings.

    ------------------
    Brad M. McGehee
    Webmaster
    SQL-Server-Performance.Com
  3. tkelley New Member

  4. Argyle New Member

    Make sure that you look into the option "enable cross-database ownership chaining" before installing SP3. If you do not check this alternative during install you will change how ownership/rights between different databases on the same server work. If your applications depend on this they will break.

    Also OPENDATASOURCE and OPENROWSET queries (via OLEDB) against remote servers is disabled by default with SP3. Though I do not know if this was the case already before SP3.

    Links:
    http://support.microsoft.com/defaul...enabling_cross45database_ownership_chain_ar5q

    http://support.microsoft.com/?kbid=810474

    /Argyle

Share This Page