Forum Replies Created

Viewing 15 posts - 16 through 30 (of 221 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....

  • 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...

  • RE: The Power Hour

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

    Paul

  • 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...

  • 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 ????....

  • 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...

  • 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 ....

  • 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...

  • 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...

  • 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

  • RE: Replication Users

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

    Rgds,

    Paul Ibison

  • 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...

  • 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...

  • 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...

  • 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...

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