So you have linked servers to all possible values of "@server" ?

If you do you need also map a remote logins so that this works.

you are missing the schema, aren't you ?

Also retrieving "all" records is a bad design. You should think about retrieving "some" of them.

Let me explain why I said that.

- Replication can affect the Publisher if the subscriber is down. So Do you really want to affect Production if TEST has a problem...

vboucharas (4/14/2009)

---

Dear all,

I have the following tables (simplified):

Object (An Object represents a house with a postcode)

ObjectID (int) (PK)

PostCode (varchar)

Client (A Client represents a customer)

ClientID (int) (PK)

PostCodeRange (A PostCodeRange represents a...

Replication Monitor will indicate xact_number ... use it with sp_browsereplcmds.

If you are using snapshot replication your indexes won't be fragmented because they are freshly created every time. If you are using transactional replication you do need re-indexing jobs on...

Yes. But be careful not...

If you can tell which tables are going to be modified maybe you just need to snapshot "only" those tables plus the new ones and be done in a fraction...

Replication from TEST to PROD or from PROD to TEST is never a good idea.

VG (4/7/2009)

---

HI,

We recently added indixes as a part of the replication process from publisher to sunscriber. I see indexes at the replicated databases. MY question is, though indexes are replicated,...

Hi Paul,

You are...

Jay Kusch (4/6/2009)

---

BOL to the rescue again (once you hit on the right combination of words - lol).

We are going to be able to execute this process leveraging Replication and...

you may want to try binary_checksum over the varchar(max) column!

Ziljan,

If you add the new tables to the publication and you run the snapshot agent ONLY that table should be sent over to the subscriber(s).