> But my SQL7 EM (enterprise manager) doesn't work with SQL2000. > I can install MSDE from my Office2000 CD, but when I do it says > I have EM installed and it is not allowed. > > I could use Access, but that has different table structures > and datatype names and the SQL is different. I'd rather work > directly in the SQL Environment if I can. > > Does anyone know how I can get round this? Can I have both > SQL7 and SQL2000 tools installed on the same machine?
No, not exactly. You can have both SQL Server 7 and SQL Server 2000 installed on the same machine, if you do it correctly, but once you install SQL Server 2000, it will replace your SQL Server 7 client tools (Enterprise Manager, etc) with the SQL 2000 versions of those tools. You can use the 2000 versions to administer SQL Server 7. For local development purposes, you might find it easier to simply migrate all of your local SQL 7 databases to SQL 2000. There's very little difference, and you can easily transfer data from SQL 2000 to SQL 7. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ______________________________________________________________________ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation � $99/Month � Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona 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
