MartyConnelly
martyconnelly at shaw.ca
Sun Aug 8 11:25:54 CDT 2004
There are some glitches; some maybe sorted out with the Final release.. 1------------------------------------------------- SQL Express can't run on XP Home. There are rumors you may be able to modify TCP ports to get around this. System Requirements for Express http://lab.msdn.microsoft.com/express/sysreqs/ 2 -------------------------------------------------- FAQ: Installing SQL Express side by side with SQL 2000 Enterprise Manager seems to break EM. It is still broken when You uninstall Express. SQLDMO9 is culprit. MS is supposed to release a new compatible version of EM to work with Beta real soon now. http://blogs.msdn.com/sqlexpress/archive/2004/07/04/172956.aspx http://blogs.msdn.com/sqlexpress/archive/2004/07.aspx 3 ------------------------------------------- I noticed that the DTS Runtime will not be included with SQL Express. In Access, you get the DTS Runtime when you install MSDE 2000. Does this mean that DTS will not be available to Access without full install of SQL Server 2005 not the Express version? . 4 ------------------------------------------------- SQL Server Express doesn't install any test databases but there is a sample pubs database script install from download pages. I think you can install side by side with MSDE but you will break EM Susan Harkins wrote: >It's true. :) > >Susan H. > >Hi all > >Browsing Mike Gunderloy's newsletter I noticed this which I haven't seen >mentioned anywhere else and makes a big difference between the earlier MSDE >and the new SQL Server 2005 Express: > >--- > >One of the nicest things about SQL Server Express is what's been left >out: the query governor from MSDE, which added arbitrary slowdowns when you >had more than five active connections, is gone. This makes SQL Server >Express a much more useful tool. In particular, many database-backed Web >sites should be able to get by with this version of SQL Server and not pay a >dime in licensing fees. The maximum size of databases is also doubled from >MSDE, to 4GB. Maximum memory, however, is halved to 1 GB. Still, the >majority of small and medium sites won't have a problem with this. > > > -- Marty Connelly Victoria, B.C. Canada