Just to let you know this is a known error and was fixed in SP 1 of SQL
server 2k
Thanks,
Neil
----- Original Message -----
From: "Bill Davidson" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, May 14, 2001 7:26 PM
Subject: Re: SQL 2000 Database List.
> 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
