Hooking Enterprise Mgr to MSDE?

[CInman]

Is it possible to hook up SQL Enterprise Manager to manage MSDE server?

I'm looking to have a small SQL Server, and MSDE seems to be the answer (cost free, etc.) but I cannot "manage" it (e.g. restore db, create db, etc.) ... if I cannot use Enterprise Manager, then how do I do it?

 

[SQLBill]

Look in the Books OnLine for osql. You use command line instructions/scripts.

-SQLBill

 

[mpeschka]

I've never tried it myself, but I do know people who have successfully connected Enterprise Manager to MSDE with little or no work. I'm sorry I can't be of any more help than that.

 

[tlbroadbent]

You can only use the SQL Server client tools, such as Enterprise Manager, if you have a licensed edition of SQL Server (Standard, Enterprise, Developer). If you do have proper licensing, then you can connect to MSDE as easily as any version of SQL Server.

I use OSQL and MS Access to administer MSDE on my home PC. MS Access projects make administering MSDE rather easy, though not as easy as EM and QA. There are several online articles available, explaining how to administer MSDE with Access, ASP or VB. Some of these include downloadable code.

SQL-DMO Picks Up Where Enterprise Manager Leaves Off

http://www.sqlmag.com/Articles/Index.cfm?ArticleID=16265

Programming SQL-DMO from Access

http://www.sqlmag.com/Articles/Index.cfm?ArticleID=8804

Doing DBA Chores with SQL-DMO

http://www.sqlmag.com/Articles/Index.cfm?ArticleID=20105

Managing Your MSDE Database

http://www.sqlmag.com/Articles/Index.cfm?ArticleID=23180

Using Microsoft Access 2002 with MSDE 2000

http://msdn.microsoft.com/library/en-us/dnacc2k2/html/odc_msdeintro.asp

Managing SQL Server with VB

http://www.winnetmag.com/Articles/Index.cfm?ArticleID=2883

faq183-1637 shows "How can I script my SQL Server databases from Visual Basic?" using SQL-DMO.

MSDE.BIZ has some MSDE products for sale and demo. I've not used them but may download one of the tools this weekend to test.

http://www.msde.biz/

If you want to get the best answer for your question read faq183-874 and faq183-3179.
Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm