Everything you say has been my experience also, so I don't have anything else to add. Enterprise manager is definitely the tool of choice for viewing tables and the like (Assuming you aren't using one of those programs to do your data modeling )
At 11:19 AM 5/21/2002 +1000, you wrote: >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
