SQLExecMS 2.7

License: Free Trial ‎File size: 5.00 MB
‎Users Rating: 3.0/5 - ‎1 ‎votes

SQLExecMS is a lightweight but powerful tool for Microsoft SQL Server DBAs and database developers.It supports MS SQL Server 7, 2000, 2005 and MSDE. Unique all-in-one interface for management, tuning up, development, deployment and data manipulation. Ultimate tool for MSDE developers and administrators. SQLExecMS doesn't require any additional installation, just 'drop and run', that is why it is almost perfect to be built in to your DB product. SQLExecMS doesn't use DMO or any other ActiveX components, this is one of the reasons why it works much faster than other similar tools. Finally, this application has been created based on long experience of development and of support DB systems. Llist of features divided by categories: -for DBA - Monitor active connections, oldest transactions and vital SQL server performance counters;Check utilization of proc cache;Watch locks; Review space used by DB files, tables and indexes; Manage DB file and filegroups;Turn on and off trace flags;Manage scheduled jobs; Change SQL server and database options;Backup and restore databases; Analyze fragmentation of tables; Analyze wait statistics; Manage indexes and analyze the selectivity of an index; Attach/Detach databases; Review error logs of SQL server; Manage extended stored procedures; Manage logins and users;Use bulk insert. -for Developers-Execute any T-SQL statements;Review estimated execution plan;Find substring in objects DDL; Use SQL history of your sql statements; Use quick reference and assistant; Easily view the table and view data;Manage triggers;Manage indexes;Compare scripts of two databases; Review objects dependencies in tree-like view; Review object properties; Find an object by its ID;Generate SQL script for your DB. And many other handy features....

VERSION HISTORY

  • Version 2.7 posted on 2009-03-12
    support for SQL Server 2008
  • Version 2.6 posted on 2006-02-26

Program Details

EULA

END-USER LICENSE AGREEMENT FOR SQLExecMS version 2.6. IMPORTANT-READ CAREFULLY. This SQLExecMS End-User License Agreement ("EULA") is a legal AGREEMENT between you (either as a registered individual developer or as the registered developer/representative and on behalf of a single entity) and Oleg Dantchenko for the SQLExecMS software product identified above. By installing, copying, or otherwise using the SQLExecMS, you agree to be bound by the terms of this EULA. If you do not agree to the terms of this EULA, then DO NOT install or use the SQLExecMS. The SQLExecMS is distributed as try-before-you-buy. 1. All copyrights to SQLExecMS are exclusively owned by the author - Oleg Dantchenko. 2. Anyone may use this software during a test period of 30 days. Following this test period of 30 days or less, if you wish to continue to use SQLExecMS, you MUST buy a license. 3. Once licensed, the user(s) is granted a non-exclusive right to use SQLExecMS in way described below a) PERSONAL license: User can use SQLExecMS on one computer, for any legal purpose, at a time. The registered software may not be rented or leased, but may be permanently transferred, if the person receiving it agrees to terms of this license. If the software is an update, the transfer must include the update and all previous versions. b) SITE license: Unlimited number of legal active employees of licensed Corporate/Company located in one particular physical location (office) can use SQLExecMS. As soon as user leaves the licensed Corporate/Company he/she loses the license for using SQLExecMS. The registered software may not be rented, leased or distributed as a part of licennsed Corporate/Company's product or package. c) CORPORATE license: Unlimited number of legal active employees of licensed Corporate/Company can use SQLExecMS. As soon as user leaves the licensed Corporate/Company he/she loses the license for using SQLExecMS. The registered software may not be rented, leased or distributed as a part of licensed Corporate/Company's product or package. 4. The SQLExecMS unregistered trial version, may be freely distributed, with exceptions noted below, provided the distribution package is not modified. No person or company may charge a fee for the distribution of SQLExecMS without written permission from the copyright holder. The SQLExecMS unregistered trial version may not be bundled or distributed with any other package without written permission of the copyright holder. 6. SQLExecMS IS DISTRIBUTED "AS IS". NO WARRANTY OF ANY KIND IS EXPRESSED OR IMPLIED. YOU USE AT YOUR OWN RISK. THE AUTHOR WILL NOT BE LIABLE FOR DATA LOSS, DAMAGES, LOSS OF PROFITS OR ANY OTHER KIND OF LOSS WHILE USING OR MISUSING THIS SOFTWARE. 7. You may not use, copy, emulate, clone, rent, lease, sell, modify, decompile, disassemble, otherwise reverse engineer, or transfer the licensed program, or any subset of the licensed program, except as provided for in this agreement. Any such unauthorized use shall result in immediate and automatic termination of this license and may result in criminal and/or civil prosecution. All rights not expressly granted here are reserved by Oleg Dantchenko. 8. Installing and using SQLExecMS signifies acceptance of these terms and conditions of the license. 9. If you do not agree with the terms of this license you must remove SQLExecMS files from your storage devices and cease to use the product.