Forum Replies Created

Viewing 9 posts - 1 through 10 (of 10 total)

  • RE: Implementing replication over the Internet

    This is also the SERVER network utility and NOT the CLIENT network utility. This entry exists on the SQL Server, NOT on the client.

    The Client Network Utility does support...


    Mike
    SQL Server MVP
    http://www.mssqlserver.com

  • RE: Implementing replication over the Internet

    Well, I would disagree. I have never used an lmhosts file and do not recommend doing it. I have not had a single problem implementing the way I...


    Mike
    SQL Server MVP
    http://www.mssqlserver.com

  • RE: Deleting Records should not affect other Database

    I would NOT suggest transformable subscriptions unless you are already 100% comfortable with all aspects of replication. Doing so makes it impossible to validate that you are synchronized, troubleshooting...


    Mike
    SQL Server MVP
    http://www.mssqlserver.com

  • RE: Domain replication to non domain computer

    You can use a domain account. You just have to deal with multi-domain trust issues and all the rest of those problems which you can't normally control. It...


    Mike
    SQL Server MVP
    http://www.mssqlserver.com

  • RE: Replication in a Cluster

    With a MASSIVE difference when dealing with cluster failover, version of SQL Server, etc. If you are hitting SQL Server 2000, it is much cleaner. Doing it against...


    Mike
    SQL Server MVP
    http://www.mssqlserver.com

  • RE: Domain replication to non domain computer

    None of that is necessary and won't fix or solve the problem.

    Create a local account on each machine that has the same name and password. Make this account a...


    Mike
    SQL Server MVP
    http://www.mssqlserver.com

  • RE: Deleting Records should not affect other Database

    Well, you are going to have a mess. Why? Because replication is designed to keep the data in synch. It is not designed for "Keep my data...


    Mike
    SQL Server MVP
    http://www.mssqlserver.com

  • RE: Implementing replication over the Internet

    You have to use IP addresses to make this work. The first hurdle is getting through the firewall/proxy server. You need to startup the Server Network Utility on...


    Mike
    SQL Server MVP
    http://www.mssqlserver.com

  • RE: Using Transaction and Merge Replication together

    It does not populate because merge is managed by a set of triggers behind the replicated tables. These triggers are coded to ignore anything that is done using a...


    Mike
    SQL Server MVP
    http://www.mssqlserver.com

Viewing 9 posts - 1 through 10 (of 10 total)