Post reply

DTS / Replication help needed Please

  • August 10, 2006 at 3:18 am

    #169666

    Hello guys I have setup snapshot replication to one of our remote servers, the only problem is though that instead of the whole table for one of my articles I now need only a slice of the data for this article that I can organise into a view.Is it possible for me to change the original source table into a view and if so where do I do it I assume it is in the dts that got created with the snapshot?

    Would this be on the right track please?

  • August 10, 2006 at 10:55 am

    #654378

    I really think you might need a good read of BOL.

    you can set up a restricted snapshot on table columns - it's in the advanced options - don't really understand the reference to a view and dts doesn't figure in replication.

    [font="Comic Sans MS"]The GrumpyOldDBA[/font]
    www.grumpyolddba.co.uk
    http://sqlblogcasts.com/blogs/grumpyolddba/

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply