SPEditor v1.7
|
Version 1.7.7 now available! See
the changelist and download links below. |
| Welcome to the semi-private SPEditor 1.7 beta!
Please note that you should have Enterprise Manager or the SQL
DMO objects installed before attempting to run SPEditor. |
Please be aware: I am looking for active feedback!
Whether its a bug or an inconsistency, I want to know about it! Please be
specific and complete when notifying me about issues... For example "When I do
x, y, z in that order, error #5 appears" or "In dialog x, text box y doesn't
automatically select the text when clicked".
speditorbugs@boneville.net
Features:
- full color syntax highlighting (with customizable
syntax file)
- stores server presets
- recognizes keywords, table names, etc and displays popup tooltips with
help
- autocomplete for common SQL commands
- load stored procedures and/or functions
- create new stored procedures
- delete and/or modify existing stored procedures
- editor options:
show line numbers
show whitespace as printable characters
align toolbar to top/bottom, small/large icons, text/no-text
custom font and font size
- can auto-save ".sql" script of stored procedure into a
designated folder, separated by server and/or database. (auto-backup for all
your work!) To restore a procedure/function, or copy it to another server,
just run the ".sql" file against the database
- Tables/fields listing. shows you the tables and field
types (window can be made always-on-top)
- prints stored procedures
- 'compile' your procedure to test it for accurate
syntax before actually saving it -- useful if you need to make a change on a
production database and don't have a test system available
- server presets are stored with 128-bit encryption to
protect stored passwords from snooping
|
Note on updates: The latest version, 1.7.7, no longer makes use of
InstallShield. I will take the time to script a new install, but for now
to simplify things just follow these instructios.
|
| Install instructions:
|
I apologize for the quality, but here is a screenshot of the
main window along with the Tables toolbar. The tables toolbar can be made always
on top and clicking the "TABLES" button slides out a list of tables to choose
from. This makes things MUCH easier when writing stored procedures to see
exactly what fields you are looking for and their type.
