SQLExecMS 2.6

SQLExecMS general info

Unique all-in-one interface for management, tuning up, development and data manipulation.
Consolidates a lot of SQL Server admin and debug features into one program. Great tool for MSDE admins. Could be used like a substitution for EM and QA.

SQLExecMS Full Description

SQLExecMS is a lightweight but powerful tool for Microsoft® SQL Server DBAs and database developers.It supports MS SQL Server 7, 2000 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....

Software related to SQLExecMS

• askSam 6.0
  Turn different types of information into searchable databases with askSam.
  
  SQLSourceSafe V3.1.008
  The integrated version control solution for SQL Server database
  
  SQLite3 database manager LITE 5.1
  SQLite3 database manager. Development tool for managing all database objects.
  
  Subject Search Sleuth 3.01
  Searches in huge collections of files on PC and LAN; includes API for developers
  
  myLittleAdmin 2.7
  myLittleAdmin is a web-based MS SQL and MSDE database administration tool.
  
  Superior SQL Builder 2.1
  The fastest, easiest way to build complete SQL scripts.
  
  Paradox viewer 1.87
  Paradox Viewer: direct and fast read any Paradox table
  
  dBase viewer 1.87
  dBase Viewer: direct and fast read any xBase table
  
  QueryToDoc Standard Edition 2.0
  Use QueryToDoc to export Oracle and MS-SQL query results to a Word Document
  
  SQL Admin Studio 2.1.2010
  SQL Admin Studio a powerful SQL Database Management Tool.
  
  

SQLExecMS Rating: