SQL Server 7.0

[LOS]

How do I automate Replication over a dial-up network [sig][/sig]

 

[TomSark]

If by automate, you mean program an application to synchronize a subscription, then you can use the following Active-X objects:

(1) SQL Merge Object for merge replication
(2) SQL Dist Object for transactional and snapshot replication

If you don't mean this, then I have no idea what you are talking about. What are you talking about when you say 'automate'?

Tom [sig][/sig]

 

[LOS]

Merge Replication is in use. However, this has to be manually sychronised every day. How do you automate dial-up from SQL Server 7.0 to allow merge to take place? [sig][/sig]

 

[i1nguyd0]

How do I query against a table using CONTAINS clause in which there is a character '#' as part of data?

For example:
Select * from TABLE_A where Contains(COL1, 'C4139A#ABA')

COL1 is already defined as fulltext column. [sig][/sig]

 

[TomSark]

I would write a VB application that does this and have it use the SQL Merge object to kick off the synchronization...

Tom [sig][/sig]