EMS SQL Manager for SQL Server Freeware 3.2

EMS SQL Manager for SQL Server Freeware 3.2 provides a perfect tool for MS SQL/MSDE administration. It has minimal required set of instruments for those users who are new to MS SQL server and need only its basic functionality. It makes creating and editing MS SQL Server database objects easy and fast, and allows you to run SQL scripts, manage users and their privileges, simply edit SQL queries and more.

Major Benefits:

1. FREE One Year of Maintenance already included!
2. FREE software updates and upgrades during Maintenance period!
3. FREE and unlimited Technical Support during Maintenance period!
4. Reasonable pricing for Maintenance renewal – from 20% per Year!
5. Volume discounts when buying two or more copies of one product
6. Cross-selling discounts on related products

Major Features:

1. Support of SQL Server 2008
2. Support of Unicode data
3. Rapid database management and navigation
4. Easy management of all SQL Server objects
5. Advanced data manipulation tools
6. Effective security management
7. Excellent visual and text tools for query building
8. Impressive data export and import capabilities
9. Visual Database Designer to handle database structure in a few clicks
10. Easy-to-use wizards performing SQL Server administrative tasks
11. Powerful tools to make your work with SQL Server as easy as it can be
12. Report designer with clear in use report construction wizard
13. New state-of-the-art graphical user interface

Enhancements:

1. Service Broker support. Now all Service Broker objects are supported: message types, contracts, queues, services, routes, remote service bindings.
   
2. SQL Server 2008 support.
   
   • Support of new data types: date, datetime2, datetimeoffset, time, hierarchyid, geometry, geography.
   • Support of table types is implemented. Table types are displayed at the UDTs branch within the DB Explorer tree.
   • Backup Database wizard now supports new backup parameters such as compression, buffer count, max transfer size.
   • Support of logon triggers is implemented. Logon triggers are created in the Server DDL Trigger Editor. New DDL trigger events are currently supported as well.
3. The ‘Same queries for all databases’ option is added to the SQL Editor. With this option enabled SQL Editor stores all queries in a shared repository, so that switching to another database does not cause loading that database queries (applying that option does not affect the currently opened copies of the SQL Editor). The values of the option can be changed freely without any risk to lose the query repository content.
   
4. SQL editors.
   
   • Some functions work quicker now.
   • Now you can change the size of the Code Completion list.
   • The ‘Search next’ feature now works even if the ‘Find dialog’ was opened for another SQL Editor.
5. Job History tool. Jobs can now be edited, stopped, run and deleted directly within the Job History form.
   Server Log Viewer. Time in the date field is now displayed with milliseconds.
   
6. Now on attempt to connect to a database the compatibility level is checked; and the prompt for changing it is displayed, if needed.
   
7. The ‘Invalid date’ error occurred when entering a date with different languages set at the first and last tabs of the Control Panel | Regional and Language Options dialog. Fixed now.
   
8. In some rare cases the ‘Multiple-step operation generated errors’ error used to occur when executing a query containing XML fields. Fixed now.
   
9. Activity Monitor. After refreshing the content, filtering options used to be reset. Fixed now.
   
10. Dependency tab. The dependencies used to be displayed improperly for some types and procedures. Fixed now.
    
11. Location of toolbars within the program main window used to be reset. Fixed now.
    
12. Print Metadata. The table field comments were not displayed. Fixed now.
    
13. Visual Database Designer. The default settings for the diagram were not applied to its first tab. Fixed now.
    
14. Data Export. Now you can export all results of the multi-recordset query.
    
15. BLOB Editor used to allow editing data even in read-only levels. Fixed now.
    
16. Fixed the error occurred on attempt to connect to a database using the password which contained punctuation marks.
    
17. Many other small improvements and bugfixes.

Requirements:

• 300-megahertz (MHz) or higher Pentium II-compatible processor; 600-MHz or faster processor recommended
• Microsoft Windows NT4 with SP4 or later, Microsoft Windows 2000, Microsoft Windows 2000 Server, Microsoft Windows XP, Microsoft Windows 2003 Server, Microsoft Windows Vista
• 64 MB RAM or more; 128 MB or more recommended
• 50MB of available HD space for program installation
• Super VGA (800x600) or higher-resolution video adapter and monitor; Super VGA (1024x768) or higher-resolution recommended
• Microsoft Mouse or compatible pointing device
• Microsoft Data Access Components (MDAC) or SQL Server Native Client
• Local or remote SQL Server 7, SQL Server 2000, MSDE, SQL Server 2005 (We do not support SQL Server 2005 Compact Edition)

 WareSeeker Editor