Assumption Correct. Reseeding subscriber prior to...

Good qualities for a DBA 😉

steve smith (3/16/2009)

---

Noel -

Thanks. I can verify. The issue is fixing if it's wrong. In general, as a 'newbie' I find it easier to stop existing replication...

Duplicate. Please delete this entry.

use a subquery like

Select

From

(

Select ...

sum(Case when answera = 2 then 1 else 0 end) as answera

...

Alan Vogan (3/16/2009)

---

One more note - I left the distributor transaction retention at the default 0-72 hours and history at 48 hours. How do you determine what the best setting...

steve smith (3/13/2009)

---

Roy, to answer your question: 10%, with a restriction of 2,097,152 MB. Since the database is not housed on a 2+ TB drive, that limit is...

you should be fine then!

ritesh (2/16/2009)

---

Hi mohan thanks for the reply. But i have deleted the publication and the susbsciption databases also which are parameters to the SPs. yet the name of the replication...

not synchronizing = agent not running or scheduled to run but not running now.

That is normal for Merge.

I believe is_subscribed does NOT works. In fact, I think it never did after 7.0.

Alan Vogan (3/16/2009)

---

We have a datawarehouse server (DW) acting as a subscriber/distributor and a production server (PROD) acting as the publisher. Also, the network folder that the publisher is writing...

skjoldtc (3/11/2009)

---

Unknown... that's how I feel sometimes when trying to figure out my wife.

SELECT Response FROM dbo.Husband

WHERE Question = 'Honey, do I look fat in this?"

AND ...

NICE

I like it!