SQLExecMS 2.7

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....

Keywords: MS SQL, MSDE, T-SQL, Query Analyzer, Enterprise Manager, SQL, Tool, DBA, SQL Express

Click to enlarge

Author:

Laplas Soft     Other programs by Laplas Soft

Downloads:

9

Size:

4882K

Cost:

$119.00 US

Users Rating:

    Reviews (0)     Write review

Feedback:

Report broken download     Report spyware [?]

License:

Shareware [?]

Operating Systems:

Release Status:

update (2009-03-12)

Recent Changes:

support for SQL Server 2008

Supported Languages:

English

Additional Requirements:

MDAC 2.6, OleDB for SQL Server

Database Assistant
Manipulate data from a variety of databases including Oracle, SQL Server, et al

AdeptSQL Diff
Database schema difference viewer and synchronization tool for MS SQL Server

MDB2SQL Professional
MDB2SQL automates MS SQL Server support for MS Access-based applications

OmniView
OmniView lets you directly edit or query data with no knowledge of SQL

DB SynchroComp
Analyze, compare, and synchronize SQL Server 7 - 2005 structures

MSDE Manager
MSDE Manager allows you to do all of the common operations of MSDE admin.

Express Agent
Express Agent lets you schedule and execute jobs and backups for SQL Express.

Data Exchange Wizard
Data Exchange Wizard Loads or export data from/into ANY database

ETL-Tools QlikView Connector
Transform and validate data while loading it into QlikView

DBDocumentor
Produce cross referenced and hyperlinked documentation of SQL databases.

FlowHeater
ETL-Tools QlikView Connector
Universal SQL Editor
SQLite Developer
Reportizer
Visual Importer ETL Standard
Small Library Organizer Pro
MyDbExplorer
Advanced XLS Converter
ESF Database Migration Toolkit Standard

Advanced XML Converter (361 dl.)
CDBF for Windows (351 dl.)
Export Table to Excel for SQL Server (336 dl.)
BBAutoHarvest (329 dl.)
Data Exchange Wizard (305 dl.)
Database Oasis (297 dl.)
Visual Importer ETL Standard (295 dl.)
Export Schema to SQL for SQL Server (287 dl.)
FmPro Script Diff (282 dl.)
EMS Data Import for Oracle (281 dl.)