It's OK Mike, *I* knew what you meant. Yes, the MSSQL2K EM works with MSSQL7. If you do get a copy though - and I'm not sure what the licensing for it is - make sure you apply the MSSQL2K service pack. There's a particularly nasty bug where EM will connect to a server, then sit there for ever trying to download all the databases. Servers with a lot of databases are affected more than those with only a
few, although I'm not sure what the threshold is. HTH, Kay. > Ok, I mean EM. Enterprise Manager- the database administrator front > end. > > I'm dislexic ko? What so? <g> > > If the SQL7 Enterprise Manager doesn't work with SQL2000 does the SQL2000 > one work with SQL7? Where could I get it if I don't own a SQL2000 server? > > Cheers, > Mike Kear > Windsor, NSW, Australia > AFP WebWorks > > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > Sent: Sunday, December 23, 2001 3:33 AM > To: SQL > Subject: RE: SQL2000 and SQL7 together . .. possible? > > What's the ME? > > ---- Original Message ---- > From: Mike Kear <[EMAIL PROTECTED]> > Sent: 2001-12-21 22:46:14.0 > To: SQL <[EMAIL PROTECTED]> > Subject: SQL2000 and SQL7 together . .. possible? > > I am in the process of migrating my sites from a host using SQLServer 7 to > another hosting company that has SQL2000. I still need to keep the SQL7 > going till everything's moved and tested, but I also need to set up on > the SQL2000 and do development work there. > > But my SQL7 ME doesn't work with SQL2000. I can install MSDE, but when I > do it says I have ME 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. > > Does anyone know how I can get round this? Can I have both SQL7 and SQL2000 > tools installed on the same machine? > > Also, I own a SQL7 server myself, but I don't own a SQL2000 server. > Is the ME for SQL2000 available anywhere other than the server disk? > > Cheers, > Mike Kear > Windsor, NSW, Australia > AFP WebWorks > > ______________________________________________________________________ Macromedia ColdFusion 5 Training from the Source Step by Step ColdFusion http://www.amazon.com/exec/obidos/ASIN/0201758474/houseoffusion Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
