Desktop Engine (MSDE 2000) - how to set up jobs, etc? 2

[christer99]

There is no MMC in MSDE 2000, so how do I set up jobs, import tables, or create new columns, etc when there is no management interface? Am I missing something? I am used to the full SQL 2000 MMC.

 

[mrdenny]

For MSDE you have to use osql.exe or isql.exe (the command line apps) to do everything. You have to do everything through code as there isn't a GUI for MSDE.

Now if you have full blown SQL and you already have Enterprise Manager installed you can connect via that to MSDE and manage the database with it.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[fredericofonseca]

No not missing anything. It doesn't have it.

new version (2005) will have something. Haven't tried it yet.


For 2k look at

http://www.asql.biz/DbaMgr.shtm

It will not allow you to setup Data Transformation Packages though.


But to create tables or any other task like that you can use code very easily. if you don't know how to do it then you should probably start doing it just for the experience.

Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com

 

[christer99]

Great. Thank you