.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
MarieAdela
Imran Ghani
Post New Web Links

How to re-add repl_distributor.

Posted By:      Posted Date: August 29, 2010    Points: 0   Category :Sql Server
 
Hello All, By mistake I have deleted the repl_distributor server object, but now I need this for replication how can we re-add this. I tried to use below command for the same EXEC master.dbo.sp_addlinkedserver @server = N'repl_distributor', @srvproduct=N'SQL Server' it add repl_distributor to the server list but also point data_source to repl_distributor. Because of that I am getting error when I try to add some distributor using EXEC sp_adddistributor. It says "The server 'repl_distributor' is already defined as a Distributor. To reconfigure the server as a Distributor, you must first uninstall the exisiting Distributor. Use the stored procedure sp_dropdistributor, or use the Disable Publishing and Distribution Wizard." Please help me adding repl_distributor to the MSSQL Database 2008 enterprise edition. Thanks in advance.


View Complete Post


More Related Resource Links

Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend