Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

not sure I understand this but I am going to throw my assumption out there:

SQL Server 2008 Standard & Enterprises editions are for running full database services on server (not just but for comparative sake),

and SQL Server Developer Edition is what, an IDE for developing programs around SQL Server???

not sure I understand?

share|improve this question
up vote 7 down vote accepted

Developer Edition is just Enterprise Edition without the license to be used in a Production environment. Also, it doesn't need to be installed on a Server OS (ie, you can put it on Win7, Vista, XP).

share|improve this answer
I believe that it is also limited to just a few connections vs. Enterprise Edition. – Joe Internet Jan 22 '10 at 5:16
@Joe Internet: Where have you seen this? I've never seen any such connection limit documented? Everything I've seen just indicates the different licence and no installation limit to servers. – Richard Jan 22 '10 at 10:06
I don't think that's true, Joe. I've happily done stress testing using Developer Edition before. – Rob Farley Jan 22 '10 at 23:34
@Richard, @Rob Farley - Yeah, I think you guys are right. I read it somewhere recently, and was a bit surprised, because I didn't think that was the case. I should have checked my facts when I read it. – Joe Internet Jan 23 '10 at 3:56
cool thanks guys! – Justin Jan 23 '10 at 5:32

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.