[dba-SQLServer] Replacement for SSMS and/or Query

Asger Blond ab-mi at post3.tele.dk
Tue Aug 22 17:19:58 CDT 2017


Or you could just use the vba editor in any office application (Word,
Excel, Access etc.), make a reference to the adodb library, and create
your queries and views by adodb recordsets and adodb commands.
/ Asger

----- Original meddelelse -----

> Fra: Arthur Fuller <fuller.artful at gmail.com>
> Til: Discussion concerning MS SQL Server
> <dba-sqlserver at databaseadvisors.com>
> Dato: Tir, 22. aug 2017 18:15
> Emne: Re: [dba-SQLServer] Replacement for SSMS and/or Query
> 
> Since sending that email, I have found two, both of which I've heard
> of but
> never used: Heidi SQL and Toad for SQL Server. I'll download them now
> and
> kick their wheels.
> 
> A.
> 
> On Tue, Aug 22, 2017 at 11:45 AM, Damien Solodow <
> Damien.Solodow at harrison.edu> wrote:
> 
> > There is a stand-alone SSMS package (which is free):
> > https://docs.microsoft.com/en-us/sql/ssms/download-sql-
> > server-management-studio-ssms
> >
> > Only other thing I can think of off-hand would be Visual Studio
> Code with
> > the mssqlserver extension...
> >
> > DAMIEN SOLODOW
> > IT Engineering Lead
> > 317.447.6033 (office)
> > HARRISON COLLEGE
> >
> > -----Original Message-----
> > From: dba-SQLServer
> [mailto:dba-sqlserver-bounces at databaseadvisors.com]
> > On Behalf Of Arthur Fuller
> > Sent: Tuesday, August 22, 2017 11:43 AM
> > To: Discussion concerning MS SQL Server <dba-sqlserver@
> > databaseadvisors.com>
> > Subject: [dba-SQLServer] Replacement for SSMS and/or Query
> >
> > Can you think of a replacement for SSMS, ideally free? I don't need
> all
> > the functionality of SSMS, but I do need to be able to create
> queries,
> > ideally graphically, execute them, and change them into views.
> >
> > You might wonder why I need this, since I already have the complete
> SQL
> > Express package. It's a long story but I'll cut to the chase. A
> client has
> > licensed a package from a vendor. This package runs on a server in
> the
> > vendor's office, and is connected to over the net. The vendor has
> denied
> > permission for me to install SQL Express on said machine, and even
> to tell
> > me how to connect to said server remotely (otherwise I could run my
> copy of
> > SSMS and connect remotely). So, at least for the moment, I'm pretty
> much
> > stuck. It's not like I have a large number of tasks to perform.
> Just create
> > a few queries and a couple of Views, which would subsequently serve
> as the
> > data source for a couple of Crystal Reports not provided by the
> vendor's
> > package.
> >
> > Any suggestions shall be gratefully received.
> >
> > Arthur
> >
> > --
> > Arthur
> > _______________________________________________
> > dba-SQLServer mailing list
> > dba-SQLServer at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> > http://www.databaseadvisors.com
> >
> >
> > _______________________________________________
> > dba-SQLServer mailing list
> > dba-SQLServer at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> > http://www.databaseadvisors.com
> >
> >
> 
> 
> --
> Arthur
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com



More information about the dba-SQLServer mailing list