Thanks Jeffry. The issue with Query Analyser is that it's quick and reliable with many things, but there's no SQL command that I've found that will give you the structure of a table. What I often need is to see all the fields in a table and their definitions. This you can see in the SQL to create the table. But Query Analyser can't give you that. ( Can it?) And tinkering with indexes and such like is near impossible using SQL but a cinch with EM. And not having EM has made life tricky indeed for all my hosted databases.
Yes, my hosting partner could give me the EM. He's in Washington DC and I'm in Sydney Australia. So as you imply, I've got the right to have a copy, because I'm paying for the client licenses through my hosting fees, but getting the host to cut a CD with it and mail it to me is not a simple task. Thanks for your help. I'll go ahead and load the EM off this eval disk and if you're wrong, I guess I'll find out in August. <g> Cheers, Mike Kear Windsor, NSW, Australia AFP WebWorks -----Original Message----- From: Jeffry Houser [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 21, 2002 11:12 AM To: SQL Subject: Re: Does EM Expire? At 10:39 AM 5/21/2002 +1000, you wrote: >Does the Enterprise Manager on the 120day eval Version of MS SQLServer2000 >expire too? No... At least not in my experience. You should be able to load Enterprise Manager and Query Analyzer without problems. The evaluation server will stop working. Theoretically your hosting partner should be able to provide you with a copy of Enterprise Manager. I have never met one that would, though. >All I want to do is get full access to my >databases on SQL2000 and MSAccess doesn't do it, and doing a lot of things >by SQL commands through the Query Analyser is clumsy and time-consuming. What are alternatives to Query Analyzer? It is functional for what I need it to do, but not the easiest / user friendly product in the world. -- Jeffry Houser | mailto:[EMAIL PROTECTED] Need a Web Developer? Contact me! AIM: Reboog711 | Fax / Phone: 860-223-7946 -- My Books: http://www.instantcoldfusion.com My Band: http://www.farcryfly.com ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
