Can I replace SQL Server Standard Edition with MSDE?

Hi,
We have a software that is developed by using MS SQL Server Standard
Edition. The vendor claims that the software cannot be used with MSDE.
The question is:
Are MSDE and SQL Server Standard Edition exactly the same from a software
point of view? Can I replace the standard edition with MSDE? Are there points
that should be considered in doing this replacement?
Thanks,
GG
hi,
GG wrote:
> Hi,
> We have a software that is developed by using MS SQL Server Standard
> Edition. The vendor claims that the software cannot be used with MSDE.
> The question is:
> Are MSDE and SQL Server Standard Edition exactly the same from a
> software point of view? Can I replace the standard edition with MSDE?
> Are there points that should be considered in doing this replacement?
> Thanks,
> GG
they both share the same code base, and actually are the same, but they do
have different in-built limitations..
MSDE includes a Query Governor that kicks in when 8 (5user+3system)
concurrent workloads are executed slowing down the whole system, it limits
CPU (2) and memory use (2gb) , it limits database size (2gb), it does not
provide FullText and Analysis Services, nor does it support Reporting
Services..
http://msdn.microsoft.com/library/de...ar_ts_1cdv.asp
it depends on your ISV requirements...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.18.0 - DbaMgr ver 0.62.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply