Replication

Rename A Subcriber
I already posted a related-connectity question in the connectivity forum, but I want to see if a workaround is possible. I need to change the name of a subscriber from "servername" to "servername,portnumber". Is there a way to do this easily? Or will I be forced to drop the current subscription, and re-creat... 2 Aug 2008 08:26

High availability for Replication
Hello all, I'm wondering what you use for High Availability when replication in place. Don't want to use MS clustering, have tried EMC's autostart and replstor couldn't get it to work.... The goal is to fail-over to a backup server and still have replication in tact. *each server both publishes AND subscribes* ... 2 Aug 2008 08:26

Drop replication without subscriber available
Hi All, I have problem with deleting my replication. I restored a database given from another server, and with it, it comes with subscriber that points to another database server. Now, when I want to remove the publication with sp_droppublication, then it tells of subscription still exist. Then I try to run ... 6 Aug 2008 00:32

merge replication and structure changes
Hello, I'm using merge replication between SQL Server 2000 and MSDE. How can I do when I need to make some changes in my db structure like: * Add. Drop or Alter column * Add Drop or Alter restriction (FK, PK) * Add Drop Table Thank you in advance Guillermo ... 4 Aug 2008 20:50

Replicated commands sometimes not executed on thesubscriber side
We have the same issue on our environment now we have upgraded to SQL Server 2005. We also have one database replicating to 2 others via 2 separate publications, but in our case, neither is an updating subscriber. Both are transactional replication, one just direct replication and the other via a DTS transformation pac... 31 Jul 2008 12:22

Snapshot error - transactional replication
We have snapshots failing to take; i.e. the bcop process goes, then indexes are applied, some transactions are applied (the snapshot being concurrent) and then the whole process starts over again - ad infinitum. Enabling verbose logging etc I found the error: ODBC/OleDB error: 42000Could not find stored proce... 2 Aug 2008 08:26

Precomputed Part. / syntax error
Trying to test out Precomputed Partitions. Publisher is SQL Server 2005 SP2 Standard Edition, subscriber is Express SP2. I set this on the articles and ran the snapshot. Now when I try to run the Subscriber (doesn't matter if I tell it to Reinitialze or not), I am getting: "Syntax error, permission viol... 2 Aug 2008 09:27

Problems with transacional replication setup
Hi @ all, i'm trying to setup an transactional replication witch actualisable subscibers (push)between two MS SQL Server 2005 Enterprise. Working on two MS Server 2003 RC2 each on virtual machines. On SERVER A: DB an and Publication is working fine refering to replikation monitor. But when im trying to set... 2 Aug 2008 09:27

Standard Operating procedure for doing a maintenance plan (SQL 2005)
Hi; Can anyone point me to a template for a Standard operating procedure and maintenance plan to keep SQL running healthy These are steps or common tasks done by an admin or a power user Thanks a bunch Rock ... 30 Jul 2008 21:00

question about multiple publications
Merge replication 2005 if i have one publication with 200 articles or 4 publications with 50 articles each - will there be any noticable speed difference between those two options? Darin *** Sent via Developersdex http://www.developersdex.com *** ... 2 Aug 2008 09:27