Replication

identity value is not reseeding in subscriber
Hi, I am reposting this from the main SQL Server forum. We are in the process of migrating from one DC to another. I setup a transactional replication using SQL backups for a database that only has two tables which are very actively updated. Here are the steps that I followed in the order: 1) Setup distribu... 8 Mar 2010 15:17

How to get name of replication agents
Thank you for your response. I don't understand what command to execute to get the name of these agents? Another question: It is possible to let the name of these agents constant? Indeed, when I drop the replication and I recreate it, the names of replication agents increments. "Ben Thul" wrote: The t... 8 Mar 2010 15:17

Compact 3.5 - replication - IIS
I am a bit confused. Does a client running SQL Server Compact 3.5 subscribing to a SLQ2008 publisher require that IIS run ON THE CLIENT?? Thanks ... 8 Mar 2010 09:41

Replication Skipped Records
Win 2003 Server / SQL 2005 SP2 Std Ed Pub/Subscribers(7-LAN, 1-WAN) / Distr (dedicated) I have a pub w/ 200 tables, approx 30gb Subscriber is across WAN. I use log shipping to sync instead of snapshot agent. When adding snapshot w/ nosync ('Repl Support Only') I have noticed severe blocking on publisher... 3 Mar 2010 16:25

skiperrors
I have setup a transactional replication and I want to be able to skip errors 2627 and 20598 due to project requirement.... The replication distriburtor job command is as follow: ( from jobs/step ( run agent )) -Subscriber [SQ01] -SubscriberDB [db_Rep] -Publisher [SQ03] -Distributor [SQ03] -DistributorSecurityM... 2 Mar 2010 19:14

Indexed Views - Clustered Index is NOT replicated (not scripte
Ben, I've used a few, leaving status at default. exec sp_addarticle @publication = N'all_objects', @article = N'ImpactCost_KD_WI', @source_owner = N'dbo', @source_object = N'theIndexedViewArticle', @type = N'indexed view schema only', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @sc... 4 Mar 2010 12:21

SQL database not accessible during transactional replication
Hello, I've setup transactional replication between two SQL servers. The publication database is on a standalone server and the subscription runs in a live environment where the database has to be accessible during replication. The subscription has some stored procedures that are used by a website. During r... 2 Mar 2010 03:31

Perform only schema change replication and avoid data replication.
Hello! I am having typical scenario in sql merge replication. I need to synchronize table with data and schema changes. But for one column in the table should not be replicated. Schema of the column should be replicated but data should not be. The column allows null so how to stop data replication for selected co... 2 Mar 2010 03:31

Indexed Views - Clustered Index is NOT replicated (not scripted by
Using SQL 2005 SP2. I have a publication that contains indexed views, and some other objects that query the indexed view using WITH (NOEXPAND). Currently replication fails because the CLUSTERED INDEX on the view is NOT replicated. I've experimented with various schema options but nothing changes. The view is r... 1 Mar 2010 17:36

Replication agents are idles
I have performed a transactional replication in my company. This done through a script SQL that I wrote. Everything is OK. However, replication agents are still idles. I need a script or a command sql to start the three agents (snapshot, journal and distribution). When I right click and I set start they work. H... 3 Mar 2010 16:25