> I remember seeing some discussion about a lite version of SQL > server that came with office xp (and 2000) pro. > > I installed it and so far cannot do anything with it..... > How do I create a db with it, and then the DNS ?
There's no GUI for MSDE, so you have to do everything from an ODBC (or other) client. First, make sure the MSSQLSERVER service is running. Then, you can connect via osql.exe (which could be in various places, depending on which MSDE version you installed - just search the drive on which you installed MSDE). From osql, you can type whatever SQL commands you like, to create databases, and to create tables and other objects within those databases. Alternatively, you can use MS Access 2000/XP as a front-end to MSDE, by creating an Access Project. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
