Please can somebody offer me some advice re SQL Server 2005? We have a
reservations database hosted by a third party supplier. Because this
database processes many transactions and is very busy, the supplier
has implemented a second database which is kept in sync with the main

SQL server 2000.
I have no replication going on. I cannot edit my client file to xpand a
column width.
I get an error stating that i cannot modify a table that is being

I am working with aa Asp.net ecommerce website with a SQL Server 2005
database and I want to replicate this database at our head office(HO)
with 2-way replication. The two servers will be connected via a VPN
over the internet. The HO has a dedicated 2MB synchronous Fibre

We keep getting a "Violation of PRIMARY KEY constraint" error. Publisher and
Distributor on one SQL 2005 server, two pull subscriptions on two other SQL
2005 servers, transaction replication initiated with backup. I have dropped
the publication and subscriptions and reconfigured ...

Hi, I have question regarding to add new articles. Right now I start snapshot
agent every time in order to replicate new table and relavant data into
subscription after I add new articles. I monitor replication and found it
seems like it re-transfer all articles into subscriber ...

Is there a way to rename a Publication (SQL 2005), either via GUI or script?
Without dropping and re-creating the Publication of course… :-)

we cannot replicate a SQL Server 2000 database with any of our
subscribers. When we start the replication for the initial snapshot,
the 5.2 Mb large snapshot.cab is downloaded, but after that, we get
the error: "The schema script '' could not be propagated to the

   Since Windows 2003 Server Domain Controllers replicate themselves, I was
wondering when Windows 2003 Server exists as a domain controller in a domain
and SQL Server also resides on that domain controller  and there is a second
Windows 2003 Server domain controller in that ...

I am getting the following error at a subscriber in a merge pull
synchronisation after adding an article to the publication:
"The process could not read file ... due to OS error 53" (where ... is
the full path to the .sch file).

Can MobSync be automated (batch file or powershell)? I have several remote
users (MSDE 2000) doing Merge Replication to a SQL 2000 publisher. I would
like to automate the process where the replication happened automatically
like a scheduled task. I have changed the values for ...

When SQL Server is running on a Windows 2003 Server domain controller and
the Windows 2003 Server domain controller is backed up to tape or disk does
that mean you dont have to do an SQL Server back up because you can restore
SQL Server from the Windows 2003 Server domain ...

How can I tell if a subscription was or was not initialized when it
was created??
Larry....

When running a merge from a C# application I get the following
message if the user is not an administrator.  It does not throw
an exception, another process seems to be displaying a dialog box.
"Invalid handle attempting to load message from resource DLL"

starting with a transactional publication, the latency of a PUSH subscription
can be improved from ~1 hr (for ~100K transactions = ~700K commands) to less
than 5 minutes by setting the SubscriptionStreams parameter to 32 ---
however, making the same parameter change for a PULL ...

I setup mirroring but it is not usable as the mirror's db is in a
"restoring" state.
So I broke the mirroring (disabled it) as restored with Recovery VS N
oRecovery......this took it out of "restoring" state, however; I was