Best thing to do is to install the full blown SQL Server MMC admin console on your PC and point it at the MSDE - it's the easiest way to administer it...it was on microsoft.com once but I can't find it anymore
HTH, Jb. -----Original Message----- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: 15 August 2002 03:11 To: CF-Talk Subject: RE: Office XP SQL server > 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
