Desktop Engine

[richself]

I hope I'm in the right place! I have installed SQL Desktop engine to develop with VB.Net. With the engine, there was no Enterprise Manager, so how does one create new databases or tables within exsisting databases? As far as I can tell, the only thing it lets me do is point to whats there already, ie, master,model, etc. But there isn't even tables in those.

 

[amrita418]

I don't think Enterprise Manager (EM) comes with Desktop edition, but you can download Microsoft SQL Server 2005 express manager to do the same I guess.

Check this link and see if that helps:

http://www.microsoft.com/downloads/...62-ec54-4299-85fc-ba05c181ed55&displaylang=en

Regards,
AA

 

[mrdenny]

You are correct MSDE does not come with Enterprise Manager. MSDE only comes with the SQL Server command line tools. One of which is called osql.exe. If will allow you to log into the database and run commands against the SQL Server such as CREATE DATABASE, CREATE TABLE, insert, select, update, delete, etc.

Denny
MCSA (2003) / MCDBA (SQL 2000)

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

http://www.mrdenny.com

(Not quite so old any more.)

 

[richself]

Tried the osql. Works great! Thanks

 

[mrdenny]

no problem.

Denny
MCSA (2003) / MCDBA (SQL 2000)

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

http://www.mrdenny.com

(Not quite so old any more.)

 

[fredericofonseca]

you can try

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

as an alternative to Enterprise manager. Won't allow you do do DTS packages, but apart from that it is pretty good.

Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com