take a look at this http://sqldbpool.wordpress.com/2009/10/07/sql-server-2008-active-passive-cluster-installation/[/url]

<<The biggest changes in SQL Server 2008 cluster is that you can now use DHCP for clustering and use IP addresses from different subnets for...

nasir_a_khan (10/3/2007)

---

Hi,

I have been assigned the task of setting up a disaster recovery server for our production Centura SQLBase server and would like to know how i can setup a...

sachindiwaker (3/25/2009)

---

insert into dbo.data_temp -- inserting records in temp table

SELECT * FROM...

take a look there: http://sql-server-performance.com/Community/forums/t/12040.aspx

so do You want to use two Ds in the same table?

mmm Danni maybe I didnt' understand your question, but for my experience on transactional replication you can replicate a table to another existing table, but the existing table on the...

this seems to work: create a publication with the same name of the oldest-deleted one, and then remove it. take a look: http://www.sqlservercentral.com/Forums/Topic125951-7-1.aspx

uh ...ok You delete the row in MSpublications...the only thing i suppose is data in the table MSarticles, where are stored the articles for any publications...try to find the articles...

try "sp_droppublication": http://msdn.microsoft.com/en-us/library/ms188363.aspx

dbaker (5/8/2008)

---

Erik Bitemo is correct that you can only have one [first-level] Distributor, and rbarryyoung has already suggested the republish option to cascade Distributors, so that SHOULD be your solution...

dbaker (4/14/2008)

---

Barry raises good question ...

rather than have 150 pubs (each with varying articles), have you considered one common pub where different subs just pick subset of avail articles ?

best...

Just 1 subscriber per publication, 150 and more publications, with articles filter per subscribers.

rbarryyoung (4/1/2008)

---

Hmm, are you certain that your Distributor is getting overloaded by the Publications? Because my sense is that they are actually being overloaded by their subscriptions.

That...

rbarryyoung (4/1/2008)

---

I don't understand, why don't you just increase the number of republishers? They would have to be on seperate servers to be effective, but than again, you're not...

Thanks for the reply, rbarryyoung.

Yes, we use republishing on the same distribution machine, that is: the online database exposes a publication, and the subscriber is the distribution database. then the...