[AccessD] SQL Server 2005 Express: No query governor

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






More information about the AccessD mailing list