[AccessD] AXP mde fe / be to fe / MSDE

Here are two free replacements for Enterprise Manager

 From BMC Software
SmartDBA Cockpit (1.6.01)
http://shop.bmc.com/product_moreinfo.cfm?id=2479&cpg=US00-1889GA

DbaMgr - DbaMgr2k
Administrative Console for Microsoft Msde 1.0 and Msde 2000 written in 
Microsoft Visual Basic 6.0 (comes with source code)
http://www.asql.biz/DbaMgr.shtm

I have only used the second because it shows you how to write the 
SQL-DMO code and seems a little easier to use.

Arthur Fuller wrote:

>On reflection, I concur with Martin. The only problem is that you need some
>sort of client to get at the sprocs and views and UDFs. I recall reading
>here that there is a way to achieve this, though. Download and install the
>eval version of SQL 2000, but install only the client tools (not the back
>end). Then you'll have Enterprise Manager, Query Analyzer etc. available
>without having to spring the big bucks for SQL 2000.
>
>-----Original Message-----
>From: Eric Goetz [mailto:accessd-admin at databaseadvisors.com] On Behalf Of
>Eric Goetz
>Sent: March 7, 2003 10:52 AM
>To: accessd at databaseadvisors.com
>Subject: RE: [AccessD] AXP mde fe / be to fe / MSDE
>
>
>
>Hi,
>
>Thanks for the feedback. I'm glad to hear that someone else is working with
>an mde fe and msde be. I like Authur's approach from a technical viewpoint.
>Unfortunately, I'm reaching the limit of the time estimate I gave to my
>client for this project. 
>
>I need to continue making progress without trying to cram the ADP learning
>curve into a two week period on top of the SQL learning curve. I also think
>getting to SQL in this rather clunky way would position me well to take on
>the web front end project if they go that way.
>
>Any more words of wisdom for me?
>
>Thanks,
>
>Eric
>
>  
>