MartyConnelly
martyconnelly at shaw.ca
Tue Apr 5 19:10:29 CDT 2005
Maybe due to the switch from SQL-DMO to SQL-SMO which the old EM is based on http://www.windowsitpro.com/Articles/Index.cfm?ArticleID=40993&DisplayTab=Article http://www.sql-server-express.com/index.html Series of 5 or 6 Articles on using SQL-SMO with Express example code in VBScript VB.Net C#.Net So you could easily translate VBScript to Access VBA list at bottom of article http://www.sqldbatips.com/showarticle.asp?ID=34 Along with this is a command utility for SQL maintenance ExpressMaint Utility http://www.sqldbatips.com/showarticle.asp?ID=29 Susan Harkins wrote: >There's almost nothing in them, but it does exist. ;) > >Susan H. > >The EM Tools came out a little later. Works with December release of Beta >SQL Express 2005. > >Microsoft SQL Server 2005 Express Manager - Community Technology Preview >December 2004 >http://www.microsoft.com/downloads/details.aspx?FamilyID=8f92556a-6c3b-47d2- >9929-ecdc5a4d25ae&DisplayLang=en > >The SAP DB or MaxDB is being supported by SAP Labs Berlin either purchased >or newsgroup 24 hour turnaround. >It is really an old ADABAS database code fork upgraded.. A .Net oledb >provider is supposed to be in the works. >I guess who ever writes it wants paid for the effort. >Otherwise ODBC. > >Jim DeMarco wrote: > > > >>What about SQL Express? The throttling limitations have been removed but >> >> >you're limited to 3-4 GB file size. This version doesn't include management >tools though AFAIK. > > >>Jim DeMarco (fresh from vacation and still wishing I were somewhere >>else!!) >> >>-----Original Message----- >>From: accessd-bounces at databaseadvisors.com >>[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Gustav Brock >>Sent: Tuesday, April 05, 2005 12:47 PM >>To: accessd at databaseadvisors.com >>Subject: Re: [AccessD] Slightly OT: Know of a good Open Source DBMS? >> >> >>Hi Joe >> >>Three option pops forward: >> >>SAP DB (totally free) or the newer MaxDB (from MySQL). >>Enterprise level (certified for SAP R/3) and complexity. >> >>Firebird. Very small install package, very easy to maintain. >>Originates from InterBase. >> >>PostgreSQL. Widely used "Oracle Light" DBMS. >>Large user base. >> >>It all depends on your requirements. >> >>/gustav >> >> >> >> >> >> >>>>>JRojas at tnco-inc.com 04/05 6:03 pm >>> >>>>> >>>>> >>>>> >>>>> >>Hi All, >> >>I was considering purchasing MS SQL Server 2000 for our company. >>We have several intranet web based applications, which currently use MS >>SQL Server 7 as the backend. >> >>The reason that I am considering the upgrade is that we are reaching >>our CAL limit. I know that I could increase the number of CALs, but I >>actually got SQL 2000 approved in this year's budget! >>The problem is that I have the feeling that the price for SQL Server >>may not be justifiable, in my mind, for what we are using it for. >> >>With that said, does anyone know of an Open Source DBMS that has the >>functionality of SQL Server? >>I know of MySQL, but when I last checked, it did not have stored >>procedures and triggers. >> >>Thanks! >>JR >> >> >> >> >> > >-- >Marty Connelly >Victoria, B.C. >Canada > > > > -- Marty Connelly Victoria, B.C. Canada