I am trying to detach a database to move to another locaion on the same
machine
The database has replication. I get the following message:
Cannot detach database while being replicated.

We are using merge replicaiton and will do
A publisher to B, C and D
E publisher to B
The data of A and E are same.  B, C and D are

Sync data between OLTP data tables and OLAP fact tables.
I have my data in several data tables, I had built a view
to aggregate the data from these data tables.
This view is similar to a fact table in OLAP Analysis

When I create a publishe and distributor and I set the snapshot
location to a network accessible drive for the subscribers to be able
to access. I get errors stating that the script was unable to run and
states a different directory than the snapshot directory. Where to I

What port is used for merge replication?
The same as clients uses to connect to SQL Server ?

updating publicatgion DB base on subscription DB changes, is that possible
to do?
and how can we make sure the orders?
cheers

One of our subscriber server is full due to transaction
log too large.  The replication was failed without no
space for the transaction log.  My question is can I
delete the transation log? Or is there any way I can free

Type Replication: Merge
Type Suscriber: Pull
1 Server Publication
5 server Suscriber's

I am trying to separate two applications sharing the same database and a few tables(like t_employee) in a phased approach. How can I best setup a bi-directional update of this t_employee table when updated by either application?
Thanks,
Memphodave

I want to update SQL Server version from 7.0 to 2000 but my installation is
replicated in another 7.0 SQL Server instance.
Can I update only the first?
Will be there any problems?

I have a database working with Merge replication, there could possibly be a
audit database associated with this replicated database.  After talking about
it we decided it would be better to have each subscriber database have a copy
of both the replication database and the audit ...

Is it possible to set up replication from Single-Filegroup to a
Multi-Filegroup?
Thanks,

I have a SQl databse on a web hosting server, and I have the databse locally
on one machine, I'd like to know if I can synchronize the data between the
two server.
In other term, I want the data locally to be updated every day, with the

For political reasons, I need to havec datas stored both on a SQL Server
2000 and a Sybase ASE v12.
If data changes in SQL, it must be replicated to the Sybase server, and if
data changes in Sybase, it must be propagated to the SQL Server.

I have Sql-Sever 2k SP2 and Win2K SP4 Advanced server.
Topology : Republisher
Publication Type : Merge with dynamic Filtering.
Everything was working out well after setting up that topology but suddenly