MOSS Forum

Ask Question   UnAnswered
Home » Forum » MOSS       RSS Feeds

SQL 2000 vs SQL 2005

  Asked By: Larissa    Date: May 14    Category: MOSS    Views: 1073

I've asked this before and no one has answered it:

What do you loose if you run MOSS 2007 on SQL 2000 SP4?

(Aside from a 64bit environment...)



4 Answers Found

Answer #1    Answered By: Vance Hardin     Answered On: May 14

MOSS can take advantage of the new SQL Reporting
Services functionality but that requires SQL 2005 SP2.
Pretty nifty stuff if you can work it.

Answer #2    Answered By: Kareem Flynn     Answered On: May 14

I don't think that you "lose" any MOSS 2007 core functionality using SQL 2000,
you just gain some SQL functionality using SQL 2K5 (as Mark said).

Answer #3    Answered By: Tyron Calderon     Answered On: May 14

Speed, security, stability, 2 node single copy clusters unless you buy
enterprise, indexing isn't as good, no ms support from april

Like they say, all the sql  stuff.

Answer #4    Answered By: Irvin Foley     Answered On: May 14

You would lose some performance, but I don't think you lose any
functionality. MOSS2007 was written to take advantage of the
performance enhancements in SQL 2005, but it will run with full
functionality on SQL 2000.

Didn't find what you were looking for? Find more on SQL 2000 vs SQL 2005 Or get search suggestion and latest updates.