I have a Sql Server 2005 sp3 with two merge publications dynamicaly
filtered :
 - publication 1 : table A with filter xxx = HOST_NAME
 - publication 2 : table A with filter xxx = null

Example:
In the table [article table] , the column [article stock] is 5
subscriber 1 sells 1 unit and updates [article stock] to 4
subscriber 2 sells 2 units and updates [article stock] to 3

We have transactional replication up and running and would like to remove a
column from a particular article (table).  Is there a way to do this?  I
found the sp_repldropcolumn for 2000, but was wondering if there was anything
2005 specific.  Also, once the column is removed, how ...

Hi, im having an issue with one of my subscribers, when you update any
row you get this errors :
Servidor: mensaje 208, nivel 16, estado 1, procedimiento
tsvw_EDC2093F08B34C1A919B32B79153D97E, línea 2

I am trying to find a way to disable and enable a publication. Can some one
tell me the correct way to do it?
My scenario is as follows:
1. Sql server 2005 merge publications (20 merge publications)

Hi All: I have a secondary server in a log-shipping scenario
(SQL2005/server2003). When I view the transaction log shipping report for
that server, the "status" shows "alert" and the last backup is from when I
first configured shipping.

Sql Server 2005
I am not a replication expert but have set it up a few times. Now I
have a very large database 150GB, with 3500+ tables that needs to be
replicated. Data will be used for reporting and is an SAP database.

hIhave a Transaction publication on SQL Server 2005. I have two different
databases on the same server (sql server 2008) that have subscriptions to the
publication. One works well and the second one receives an error : Shared
Memory Provider: No process is on the other end of the ...

Hi I am getting error when I add new table. Table is same as other tables,
but why I got error when I add this new table. The error is like:
Command attempted:
CREATE TABLE [dbo].[CCy](

I need to monitor the amount of traffic that my replies generate. I
use SQL Server 2000 and my replies are "Merge Replication". How can i
know it?
Thanks a lot and sorry for my english.

We have two servers with databases using Peer to Peer replication. We are
steering the Development teams to use Composite Keys in order to avoid
Replication Conflicts and the extra overhead of managing Identity ranges. I
know there are a number of ways to avoid confilcts i.e ...

I have a SQL Server 2005 reporting services that has numerous reports.  I
would like to create new directory for a different client style resports
using the same database instance .
Please help me with the steps to complete this task

Sql2008
I would like to replicate ONLY reference tables to the subscribers, one way
only.
What type is this?

We are upgrading from SQL 2005 to 2008 and our primary database is setup
with Merge relication with publisher and distributor both on the same
server. Our subscriptions are laptops running 2005 Express. Can we just
backup 2005 database and restore on 2008?  Also, can we keep the ...

The SQL 2000 [sp_addsubscriber] stored procedure has an @login parameter.
Is this the login for the publisher or the subscriber?  I imagine it is for
the subscriber, but I'd like to know for sure.