howard gramer
hagdb at hotmail.com
Thu Mar 27 22:54:01 CST 2003
For what it's worth..not sure what it means: A2KDH Volume 2: Enterprise Edition, pg.159 It states specifically about MSDE: "Can only be a replication subscriber, not a publisher" howard ----- Original Message ----- From: "John W. Colby" <jcolby at colbyconsulting.com> To: "AccessD" <AccessD at databaseadvisors.com> Cc: "SQLServer" <dba-sqlserver at databaseadvisors.com> Sent: Thursday, March 27, 2003 9:57 PM Subject: [dba-SQLServer]MSDE Replication - Crossposted > On a related note... > > MDSE claims to support replication. I don't know enough about MDSE, never > mind replication, to understand the issues - but... > > If each workstation ran MSDE and the server runs MSDE, then you have > effectively created SQL Server for more than "5 simultaneous users". Since > each user is now hitting a SQL Server Be on their own machine, with only > replication data going to the main BE on the server, it certainly sounds > like you could get fairly decent performance for 10 or 20 users. > > John W. Colby > Colby Consulting > www.ColbyConsulting.com