For most purposes we use Access (with all the appropriate 2000 patches) to
talk to our SQL 2000 datasources, and it's much faster than the enterprise
manager, as you connect to a single datasource, no taking forever to load
all the datasources.
I've always been tempted to go your route, Dave, as I typically like command
prompts (call me crazy), but haven't tried it yet.
-Bill
www.brainbox.tv
----- Original Message -----
From: "Dave Watts" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, May 14, 2001 7:10 PM
Subject: RE: SQL 2000 Database List.
> > I didn't have the earlier version loaded at home, but 2000 is
> > very slow when listing databases. I think they should provide a
> > "search-type" feature so that users don't have to drill-down when
> > they know what they want. Maybe more like a comand line that allows:
> >
> > "use server.dbo.database"
> >
> > I think this would save me about 15 minute a day.
> > (significant enough)
>
> You know, there is a command line interface to SQL Server, which allows
you
> to do anything that's possible with T-SQL. You can use isql or osql, which
> are true command-line clients, as well as isql/w, which is a windowed
> interface. If you find yourself performing the same sorts of tasks in
> Enterprise Manager over and over again, you might take a look at these.
You
> can't do quite everything through them, but they might suit your needs.
>
> Dave Watts, CTO, Fig Leaf Software
> http://www.figleaf.com/
> voice: (202) 797-5496
> fax: (202) 797-5444
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
