I have tried to change the Windows user account for creating the
snapshot in Management Studio (in the properties of the publication) . When
I do that, it throws an error, and the only information it gives me is: "an
exception occured while executing a Transact-SQL statement ...

i have the following problem: on my sql server 2005 i have a TABLE_A with an
after insert trigger - this trigger updates or inserts rows in TABLE_B and
also updates the inserted rows in TABLE_A... everything works fine so far
==>  data is updated correctly on server in both ...

Below is some basic DDL for a Patient and State table.  State, as in, 50
States in the USA.
Ok.  Here is what I'm after.
I want to setup transactional (pull) replication.

Guys,
I would appreciate if anyone help me out.
Let's say we have DBServer1 & DBServer2 on Montreal and DBServer3 on
Toronto.

I have a situation where our primary server is down for maintenance
and our standby server is supporting production now.  The problem is
that our primary server was replicating data to a report server.
Transaction Replication was never set up on the standby server.

Database A SQL 2K Ent doing transactional replication or log shipping
to
Database B on SQL 2005 Ent instance
Then

I was reading your article "Implementing NoSync Initializations (and
variations) on SQL Server 2005" and after (4) initialize with backup there is
a list of 3 things that needed to be done. One of them got me confused: (b)
replace timestamp columns with binary(8) columns. You'll ...

Hi, I have a transactional replication using a remote distribution db with 4
pull subscriptions. We had 2 subscribers before and were using push but there
was lot of blocking on the distribution DB before and there was no way to
upgrade the Distribution db (Cost) - therefore, I ...

We have an issue with a SQL Server 2008 to SQL Server 2005 snapshot
replication.   The Publisher is a SQL 2008 server, with a single table
publication established.  The publication is set up to allow snapshots over
FTP, and the snashot file is compressed.  The resulting file is ...

We are setting up replication with one publisher and multiple subscribers.
Are there any advantages in using a publication per subscriber vs one
publication for all subscribers?
tia

I have to syncronize two dbs one db is running SQL 2000 SP4 Ent
edition
The other  SQL 2005 SP2 Ent edition
Goal is to have data be availabe as read\write on both systems and get

If I have transactional replication in which I have a remote distrbutor, a
publisher with 3 publications, and 4 subcriptions and my distributor goes
down for approximately 12 hours.  When the distributor comes back up will I
be able to get my targets synched back up with my ...

Purpose: Move database files to a standard location
Steps:
1) Tried to detach database but failed because database is setup for
replication (publisher).

Here is the configuration....
Server A - SQL 2005
Server B - SQL 2005
Server C - SQL 2000

We are planning to keep an updated copy of our branches' databases at a
central location. Our branches' databases change in size, such as 40GB or
10GB... There are more than 10 branches.
The database structures are changed by the application developers 3 or 4