Sunday, September 14, 2008

SQL Server - changing password of replication

To change password for the subscriber , use the below sql 2000 command,

exec sp_helpsubscriberinfo
exec sp_changesubscriber @subscriber ='abcd', @password 'abcd'