Yes, that's the *licensing*. It doesn't mean that there is any
restriction actually enforced by the software itself. I'm not saying
you should use MSDN for production work, the point is that installing
from MSDN media should make no differrence in the actual performance of
SQL Server. Which is what the original post was about.

-----Original Message-----
From: Lepingwell, Christopher [mailto:Christopher.[Email Address Removed]
Sent: Thursday, December 18, 2003 8:19 AM
To: Razzano, Rick; LazyDBA.com Discussion
Subject: RE: Is MSDN installation any different from purchased CD?


I think you'll find that the licensing on all MSDN server stuff is
development/testing. The developer edition of SQL Server has full
Enterprise functionality, except for a limit on concurrent connections.
Otherwise everyone would buy MSDN and not bother with the full 25-cal
licensing or per processor models See footnotes at
<http://msdn.microsoft.com/subscriptions/levels/default.asp> for more
detail


-----Original Message-----
From: [Email Address Removed] [mailto:[Email Address Removed]
Sent: Thursday, December 18, 2003 2:05 PM
To: LazyDBA.com Discussion
Subject: RE: Is MSDN installation any different from purchased CD?


Only the SQL Server Developer Edition is limited to 5 connections. MSDN
Universal also has the Standard and Enterprise Editions, which are not
limited to 5 connections (even if installed from MSDN media).

Check the @@VERSION for the server and see what edition it is -- it
sounds like the developer edition to me.

-----Original Message-----
From: Lepingwell, Christopher [mailto:Christopher.[Email Address Removed]
Sent: Thursday, December 18, 2003 5:03 AM
To: LazyDBA.com Discussion
Subject: RE: Is MSDN installation any different from purchased CD?


MSDN installs of servers are all development versions, and limited to (I
think) five concurrent connections.

-----Original Message-----
From: Devin Wong [mailto:devin.[Email Address Removed]
Sent: Thursday, December 18, 2003 11:00 AM
To: LazyDBA.com Discussion
Subject: Is MSDN installation any different from purchased CD?


Dear all,

I have a silly question. I was trying to run scripts with several
concurrent sessions. When I ran the scripts with more than 4 concurrent
users that access the same tables, I started to get error like the
following

SQL Error State 23000, Native Error Code: A29, ODBC Error .....

I was using WinSQL to run the scripts. Would tool be the reason of the
error? My server was installed from MSDN CD. Would it be the problem?
Would you please kindly advise? Thank you very much.

Regards,
Devin

---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY Get
today's
cartoon: http://www.LazyDBA.com To unsubscribe, e-mail:
mssqldba-[Email Address Removed] For additional commands, e-mail:
mssqldba-[Email Address Removed] REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY Get
today's
cartoon: http://www.LazyDBA.com To unsubscribe, e-mail:
mssqldba-[Email Address Removed] For additional commands, e-mail:
mssqldba-[Email Address Removed] REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY Get
today's
cartoon: http://www.LazyDBA.com To unsubscribe, e-mail:
mssqldba-[Email Address Removed] For additional commands, e-mail:
mssqldba-[Email Address Removed]MS Sql Server LazyDBA home page