Replication Standard or Enterprise

In setting up replication between databases do both sql installations have to be enterprise or can it be done with both sql server standard edition.
thanks,Replication is included in Standard Edition.|||Is there a difference in using enterprise... or standard in regards to replication... I can not find much information stating the difference in choosing an edition...
here @. work ... the prod server they want to replicate has already been built using standard... but other... admins... say it would have to be enterprise...|||Is there a difference in using enterprise... or standard in regards to replication... I can not find much information stating the difference in choosing an edition...
here @. work ... the prod server they want to replicate has already been built using standard... but other... admins... say it would have to be enterprise...

Tell the other ...admins ... to take a hike:


SQL Server 2000 Standard Edition

This is a more affordable option for small-sized and medium-sized organizations that do not require the advanced scalability, availability, performance, or analysis features of SQL Server 2000 Enterprise Edition. Standard Edition can be used on symmetric multiprocessing systems with up to 4 CPUs and 2 GB of RAM.
Standard Edition includes the core functionality needed for non-mission-critical e-commerce, data warehousing, and line-of-business solutions. For instance, all of the XML features present in Enterprise Edition are also included in Standard Edition. And while a handful of advanced OLAP features are reserved for Enterprise Edition, all data mining features and the core OLAP functionality are included in SQL Server 2000 Analysis Services in Standard Edition. Similarly, components that other database vendors charge for as separate add-on products for their highest-end editions are included in Standard Edition:
Data Transformation Services (DTS)
Replication (snapshot, transactional, and merge)
Full-Text Search
English Query
Stored procedure development and debugging tools
SQL Profiling and performance analysis tools
Before choosing Standard Edition, make sure you review "Features Supported by the Editions of SQL Server 2000" in SQL Server Books Online.|||Kindly ask the "other admins" for proof of this. Perhaps, if you build the replication into the QA system (a good idea, anyway), you can prove to them it is possible.|||I appreciate the feedback... and will do a lot more research... any experienced suggestions or tips that a tutorial or book might not mention .... thanks again guys...|||Or maybe they would like to read the 2005 features for themselves:

http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx|||I have a solution that not only replicates the data (standard or enterprise, 2000 or 2005) but also load balances read-only statements and provides effective means of resynchronization. I work for a company, PCTI (Parallel Computers Technology Inc), out of the Philadelphia area. We have a product, DBx, that does Parallel Synchronous Real Time Replication (up to 16 servers, local or remote) guaranteeing zero-loss of transactions. Anyone looking for more information should visit http://www.pcticorp.com or send me a private message via dbforums.com.

Replication Problem

I don't know if anyone can help with this, I've got replication running
between 2 SQLServer installations, the distributor is on the the same
server as subscriber. Replication is a once a day snapshot and all has
been working well until recently.

I needed to make a change to the replication and deleted and recreated
the subscription and now it doesn't work. The snapshot runs as before
but the subscription fails within a second or 2 with the following error:

"The process could not retrieve security information from the Subscriber
for Distributer 'MIServer'. The step failed."

The only thing I could think of was that somehow the password for the
'distributor_admin' login had become out of step. I've run
'sp_changedistributor_password' and the subscription still fails.

Any help would be appreciated.

TIA

Laurence Breeze"Laurence Breeze" <laurence_breeze@.yahoo.co.uk> wrote in message
news:4240096D.2000305@.yahoo.co.uk...
>I don't know if anyone can help with this, I've got replication running
>between 2 SQLServer installations, the distributor is on the the same
>server as subscriber. Replication is a once a day snapshot and all has
>been working well until recently.
> I needed to make a change to the replication and deleted and recreated the
> subscription and now it doesn't work. The snapshot runs as before but the
> subscription fails within a second or 2 with the following error:
> "The process could not retrieve security information from the Subscriber
> for Distributer 'MIServer'. The step failed."
> The only thing I could think of was that somehow the password for the
> 'distributor_admin' login had become out of step. I've run
> 'sp_changedistributor_password' and the subscription still fails.
> Any help would be appreciated.
> TIA
> Laurence Breeze

It sounds rather similar to this KB article:

http://support.microsoft.com/?id=312106

But you might get a better response in
microsoft.public.sqlserver.replication.

Simon