I have setup Log Shipping and all is well. Next, I have tried to switch the roles of the Primary and Secondray roles (using sp_change_primary_role, sp_change_secondary_role and sp_change_moitor_role). The role switch was completed with no problems

What I have notice after the logins are transferred that I have LOSt the server role membership. I am reading a Microsoft article (How to set up Log Shipping) that claim that this was scheduled to be fixed in SP 1. I am currently running SQL 2K with Sp 3a

I would appreciate is someone will shed some light on this an point me in the right directio

Thnaks a lot