Getting Started with Adobe After Effects - Part 6: Motion Blur
A collection of quick technology learning tips from what people around you learn every day

Enabling the replication database in SQL Server

Oct 11 2011 7:05AM by Paresh Prajapati   

I would like to share a script to enable database for replication. So it is the step before adding publication and articles in replication.

USE master
GO

exec sp_replicationdboption @dbname = N'PublisherDB', @optname = N'publish', @value = N'true'
GO

exec [PublisherDB].sys.sp_addlogreader_agent @job_login = N'Domain\UserName', @job_password = null, @publisher_security_mode = 1
-- Or (for SQL User 'sa' or any system admin user)
exec [PublisherDB].sys.sp_addlogreader_agent @job_login = null, @job_password = null, @publisher_security_mode = 0, @publisher_login = N'sa', @publisher_password = N''
GO

exec [PublisherDB].sys.sp_addqreader_agent @job_login = null, @job_password = null, @frompublisher = 1
GO
Read More..   [0 clicks]

Published under: SQL Server Tips ·  ·  ·  · 


Paresh Prajapati
6 · 23% · 7464
4
 
1
 
 
0
Incorrect
 
0
Interesting
 
0
Forgotten



Submit

Your Comment


Sign Up or Login to post a comment.

"Enabling the replication database in SQL Server" rated 5 out of 5 by 4 readers
Enabling the replication database in SQL Server , 5.0 out of 5 based on 4 ratings
    Copyright © Rivera Informatic Private Ltd Contact us      Privacy Policy      Terms of use      Report Abuse      Advertising      [ZULU1097]