Hi there, At one point I was running both, you're right the sql7 one does not run with 2000, but the 2000 edition is backwards compaitble. I have run both db servers on the same machine.
The number one thing I hate about EM2k is that it re-writes your sql on execution. So select something from x, z where a.x *= a.z becomes select something from left join a.x on a.z which really annoys me, it's also the only supported syntax on postgres so I've had to get used to it. Still don't like the fact that it does it though. Although query analyzer leaves it alone. Max ----- Original Message ----- From: "Mike Kear" <[EMAIL PROTECTED]> To: "SQL" <[EMAIL PROTECTED]> Sent: Sunday, December 23, 2001 10:09 AM Subject: RE: SQL2000 and SQL7 together . .. possible? > 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 > > > > ______________________________________________________________________ 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 Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
