SQLExecMS 2.7

SQLExecMS 2.7 offers users a handy but professional 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 doesnt require any additional installation, just drop and run, that is why it is almost perfect to be built in to your DB product. SQLExecMS doesnt 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.

Major Features:

1. Monitor active connections, oldest transactions and vital SQL server performance counters
2. Check utilization of proc cache
3. Watch locks
4. Review space used by DB files, tables and indexes
5. Manage DB file and filegroups
6. Turn on and off trace flags
7. Manage scheduled jobs
8. Change SQL server and database options;Backup and restore databases
9. Analyze fragmentation of tables; Analyze wait statistics
10. Manage indexes and analyze the selectivity of an index
11. Attach/Detach databases
12. Review error logs of SQL server
13. Manage extended stored procedures
14. Manage logins and users
15. Use bulk insert.
    
16. Execute any T-SQL statements
17. Review estimated execution plan
18. Find substring in objects DDL
19. Use SQL history of your sql statements
20. Use quick reference and assistant
21. Easily view the table and view data
22. Manage triggers
23. Manage indexes
24. Compare scripts of two databases
25. Review objects dependencies in tree-like view
26. Review object properties
27. Find an object by its ID
28. Generate SQL script for your DB.
    
29. And many other handy features...

Enhancements: support for SQL Server 2008

Requirements:

1. MDAC 2.6
2. OleDB for SQL Server

WareSeeker Editor