This software is an all-in-one interface for managing, tuning, developing and manipulating data for SQL Server. It consolidates several admin and debug features, suitable for MSDE admins. A unique tool that can replace the functions of EM and QA.
As a lightweight but powerful tool for Microsoft SQL Server DBAs and database developers, SQLExecMS offers support for MS SQL Server 7, 2000, 2005 and MSDE. This all-in-one interface allows for management, tuning up, development, deployment, and data manipulation, making it the ultimate tool for MSDE developers and administrators.
What sets SQLExecMS apart from similar tools is that it requires no additional installation. Simply 'drop and run', making it almost perfect to be built into your DB product. Additionally, SQLExecMS doesn't use DMO or any other ActiveX components, giving it a faster performance. Created based on experience in the development and support of DB systems, this application boasts a list of features divided by categories.
For DBAs, SQLExecMS allows for monitoring of active connections, oldest transactions, and vital SQL server performance counters. Users can check utilization of proc cache, watch locks, review space used by DB files, tables, and indexes, and manage DB file and filegroups. Users can also 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, and use bulk insert.
For developers, SQLExecMS offers the ability to execute any T-SQL statements, review estimated execution plans, find substring in objects DDL, use SQL history of your sql statements, use quick reference and assistant, easily view the data of tables and views, manage triggers, manage indexes, compare scripts of two databases, review object dependencies in a tree-like view, review object properties, find an object by its ID, and generate SQL script for your DB.
With many other handy features, SQLExecMS is the ultimate lightweight tool for Microsoft SQL Server DBAs and database developers.
What sets SQLExecMS apart from similar tools is that it requires no additional installation. Simply 'drop and run', making it almost perfect to be built into your DB product. Additionally, SQLExecMS doesn't use DMO or any other ActiveX components, giving it a faster performance. Created based on experience in the development and support of DB systems, this application boasts a list of features divided by categories.
For DBAs, SQLExecMS allows for monitoring of active connections, oldest transactions, and vital SQL server performance counters. Users can check utilization of proc cache, watch locks, review space used by DB files, tables, and indexes, and manage DB file and filegroups. Users can also 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, and use bulk insert.
For developers, SQLExecMS offers the ability to execute any T-SQL statements, review estimated execution plans, find substring in objects DDL, use SQL history of your sql statements, use quick reference and assistant, easily view the data of tables and views, manage triggers, manage indexes, compare scripts of two databases, review object dependencies in a tree-like view, review object properties, find an object by its ID, and generate SQL script for your DB.
With many other handy features, SQLExecMS is the ultimate lightweight tool for Microsoft SQL Server DBAs and database developers.
What's New
Version 2.7: support for SQL Server 2008
Version 2.6: N/A
Version 2.5: N/A