General discussion


SQL Server Tools

By jolley_watson ·
Does anyone know if there are any SQL server tools that come outside of the SQL Server installation itself and how to obtain them.
I have search Microsoft and other but cannot find a set of tools or utilities to manage SQL server.
A good example would be a utility like SQL Enterprise Manager MSC. This way I can carry it on a CD so when I visit a customer site that has SQL installed, but not the server tools, they would be available.

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

by bmedlock In reply to SQL Server Tools

If you like a command prompt there's always osql. Every installation of MSSQL or MSDE will have osql installed in the bin directory.
Another option is MSAccess. If Access is installed go to File->New and create a new "Project(Existing Database)". Then you need to fill out the info to connect to your MSSQL database, and you can administer your database from Access.
Best option would be to get a laptop w/ MSSQL installed on it, then you can plug it into the customers network and administer it from there.

Collapse -

by Charles E. Deaton In reply to SQL Server Tools

I've searched for years to find other tools to manage MSSQL from 6.5 thru 2000 but have yet to find anything that will perform something that the MMC snapin, Query Analyzer and Profiler can do. There are other tools that make some tasks easier but nothing to waste your money on.

Charles E. Deaton
Database Administrator
Realcomp II Ltd.
28555 Orchard Lake Road, Suite 200
Farmington Hills, MI 48334
General 248-553-3003 / Direct 248-699-**42 / Fax 248-699-0142

Collapse -

by yaoliu68 In reply to SQL Server Tools

Check Quest Software, it has a Toad version for sql server

Collapse -

by Devegied In reply to SQL Server Tools

Yes, there are some free tools. In my opinion one of the best is DbaMgr or DbaMgr2:

Related Discussions

Related Forums