|
Free Software
eSQL -
eSQL is a simplified version of the isql/osql command line query tool that has
a very special feature. It runs the input query on EVERY SQL Server that
is registered in the Enterprise Manager. It can also run the query on one SQL
Server. Optionally eSQL can run the query on every database on every/one SQL
Server. The results of the query are sent to an html file named
eSQLResults.html in the program's directory.
eSQL was originally written in javascript for Windows
Scripting Host. When .Net was released, eSQL was modified to work with JScript
.Net and became a compiled executable.
The file eSQL.zip
contains three files:
Bld.bat, the file to build the executable
esql.js, the source code
WhoIsSA.sql, the script to run in example one below
Unzip eSQL.zip
to a new directory of your choice. Open a Command Prompt. cd to the directory
where the 3 eSQL files were unzipped and type bld. You are now ready to use
eSQL
Examples:
© 2007-2010 Gerasus Software. All rights
reserved.
|
