Forum Replies Created

Viewing 15 posts - 16 through 30 (of 222 total)

  • RE: Is Replication over DLS advisable?

    The choice to use VPN is more of a security one - you'll be able to use trusted authentication this way. Otherwise you'll be using SQL Authentication and FTP initialization....


    Paul Ibison
    Paul.Ibison@replicationanswers.com

  • RE: The Power Hour

    Perhaps it is a bug. I've seen 'Newbie' , '50 posts', '100 posts' and '????'. Perhaps it is automatically generated by the site, apart from administrators, however Morpheus (30 posts) has an...


    Paul Ibison
    Paul.Ibison@replicationanswers.com

  • RE: The Power Hour

    Thanks Remi, but isn't my avatar the Yin/Yang symbol?

    Paul


    Paul Ibison
    Paul.Ibison@replicationanswers.com

  • RE: The Power Hour

    Actually, now that I see them side-by-side I notice that this is the Profile picture and there's no white box at all for your posts. Hmmm - anyway, please can you...


    Paul Ibison
    Paul.Ibison@replicationanswers.com

  • RE: The Power Hour

    Steve,

    absolutely nothing to do with SQL, but you have a nifty piccy of what looks like a Porshe above the title of Forum Administrator - whereas my posts have ????....


    Paul Ibison
    Paul.Ibison@replicationanswers.com

  • RE: inserts and updates only

    OK - as you are not replicating the deletes, you don't want to remove the accumulated data at the subscriber? In that case the 'Keep existing table unchanged' would be...


    Paul Ibison
    Paul.Ibison@replicationanswers.com

  • RE: Replication Conflict

    It seems you have different schemas, but the publisher article is a subset of the subscriber one - it's normally the exact opposite ....


    Paul Ibison
    Paul.Ibison@replicationanswers.com

  • RE: SQL over 2 domains

    I'm confused by your last comment (it's not difficult, I know ). You seem to indicate it isn't a replication setup, so in this...


    Paul Ibison
    Paul.Ibison@replicationanswers.com

  • RE: inserts and updates only

    There is no need to implement a custom solution. Have a look at the article properties, Commands tab, and type NONE for the 'Replace delete commands with...' section.

    Rgds,

    Paul Ibison, SQL...


    Paul Ibison
    Paul.Ibison@replicationanswers.com

  • RE: Replication Rights

    Most admin of replication requires sysadmin rights, but for your purposes have a look at the replmonitor role in the distribution database.

    Rgds,

    Paul Ibison, SQL Server MVP


    Paul Ibison
    Paul.Ibison@replicationanswers.com

  • RE: Replication Users

    Have a look at the replmonitor role in the distribution database.

    Rgds,

    Paul Ibison


    Paul Ibison
    Paul.Ibison@replicationanswers.com

  • RE: replication synchonization

    It depends on how the original publication was created. If it was a nosync one, then this'll be the same and you'll have to synchronize the data first, or alter...


    Paul Ibison
    Paul.Ibison@replicationanswers.com

  • RE: Lots of questions - Delete my pain

    1: performance is the same, but some functionality is only available by replication scripts and not the GUI.

    2: Have a look at : http://www.replicationanswers.com/InternetArticle.asp

    3: You can't - you'll need...


    Paul Ibison
    Paul.Ibison@replicationanswers.com

  • RE: updatable subscriptions

    This is correct. There can be commands waiting to be delivered from the distribution database to the subscriber - in which case sp_browsereplcmds can be used - but there can't...


    Paul Ibison
    Paul.Ibison@replicationanswers.com

  • RE: HELP - The agent is suspect. No response within last...

    I am not too clear from your post exactly which agent gives this message - it seems it is both agents. If it is the distribution agent, use the current...


    Paul Ibison
    Paul.Ibison@replicationanswers.com

Viewing 15 posts - 16 through 30 (of 222 total)