Re: R2 SQL 2000 or 2005



In article <eOziFaJvHHA.736@xxxxxxxxxxxxxxxxxxxx>,
Ben@xxxxxxxxxxxxxxxxxxxxxxxx says...
Hi

We are installing new hardware for our SBS 2003 so are considering upgrading
to R2.

We have 25 users constantly using SQL Server, it currently consumes about
1.7 gb ram.

We are soon to install a remote office server using SQL Transactional
Replication, for which I understand 2005 is better.

I would like to ask how many of you have taken the plunge for 2000>2005 and
have you found yourself restricted by the Workgroup Edition Limits?

Many vendors support their DB on 2005, but not as many support the
conversion from 2000 to 2005 - check with your vendor.

--

Leythos
- Igitur qui desiderat pacem, praeparet bellum.
- Calling an illegal alien an "undocumented worker" is like calling a
drug dealer an "unlicensed pharmacist"
spam999free@xxxxxxxxxx (remove 999 for proper email address)
.



Relevant Pages

  • Re: SBS Monitoring reinstall fails
    ... -- SharePoint instance on SQL Server 2000 SP4 ... Microsoft Data Engine. ... Rerun Setup, and retry installing ...
    (microsoft.public.windows.server.sbs)
  • Re: There was a problem loading data: Generating user instance in SQL Server is disabled.
    ... When I installed VBExpress and C# Express 2008, using the default settings with only one exception it was the path for the installation since there is nothing else than the OS on C: so everything else is on D: ... Yes, I talk SQL Server and SQL Server Express without dsitinguashing them because in most cases, there is not differece in the regards of inexperienced users. ... USER INSTANCE, however, is only available to SQL Server Express. ... Since you have already get it installed into a setting that is not meet the default requirement for those sample apps, you need to learnto reconfigure the system, or you could try to uninstall and then re-install, so you have chance to studybefore installing and configuring your OS to meet the all requirements and to get the installation right. ...
    (microsoft.public.vstudio.general)
  • Help desperately needed! Struggling to re-install SQL server.
    ... I've had great trouble installing SQL server 2000 on Windows XP. ... 15:09:43 End Action ShowDialogsHlpr ... 15:10:10 End Action DialogShowSdSetupType ...
    (microsoft.public.sqlserver.setup)
  • SQL Server 2005: setup problem
    ... Could you help me please with installing SQL Servera 2005 Express ... SQLEXPR.EXE - Microsoft SQL Server 2005 Express Edition ... WMI Service Requirement (Success) ... Operating System Minimum Level Requirement ...
    (comp.databases.ms-sqlserver)
  • Re: slowing/halting stored procedure from ado.net
    ... but at the time when calling from the application ... Studio goes without any slowdown, ... There was/is no big job running on the sql server, ... execution the cached plan does not match the ...
    (microsoft.public.dotnet.framework.adonet)