EMS.SQL.Manager.2005.for.SQL.Server.v2.7.0.2

EMS.SQL.Manager.2005.for.SQL.Server.v2.7.0.2 - 21966 KBEMS SQL Manager for SQL Server is a high performance tool for SQL Server administration and development. SQL Manager 2005 works with any SQL Server versions from 7 to 2005 and supports all of the latest SQL Server features including new SQL Server 2005 permission system, assemblies, DDL triggers, XML columns, and so on. It offers plenty of powerful tools for experienced users such as Visual Database Designer and Visual Query Builder to satisfy all their needs. SQL Manager 2005 has a new state-of-the-art graphical user interface with well-described wizard system, so clear in use that even a newbie will not be confused with it.Key FeaturesFull support of SQL Server 2005 * Full support of SQL Server 2005 permission system * Assemblies, DDL Triggers, Aggregates and Synonyms support * XML indexes, included index columns, index creation and lock options * Maximum size for varchar, nvarchar, varbinary fields * Typed XML columnsNew state-of-the-art graphical user interface * MDI and floating-window styles implementation * Handy database explorer for managing all SQL Server objects * Customizable toolbars for all program windows * Fully customizable program interface * Powerful visual options module * Saving all program settings * Localizable program interfaceRapid database management and navigation * Multiple host/database connections * Database and server properties management * Registering databases for working with the required databases only * Project mode to work with the needed database objects only * Multiple user-defined tabs for any tree node to access it in one-click. * Working with multiple selected objects at a time * Grouping/ungrouping registered databases by host nameEasy management of all SQL Server objects * Creating/dropping databases and schemas * Managing tables and all their subobjects: fields, indices, triggers, checks and foreign keys * Managing views, procedures and user-defined functions * Managing assemblies, DDL triggers, aggregates, synonyms, defaults, rules and user-defined types * Duplicating all database objects * Viewing dependencies between database objectsAdvanced data manipulation tools * Powerful BLOB viewer/editor with several types of viewing BLOB data * Plenty of useful tools such as data grouping, summarizing, fast searching and filtering * Master-detail view to work with two linked tables at the same time * Table and card views to see data the way you like * Ability to copy and paste selected records * Advanced printing system * Exporting data to SQL script as INSERT statementEffective security management * Powerful login manager for administering server logins * Managing database users and user-defined roles * Grant manager displaying all database object grants in the form of a gridExcellent visual and text tools for query building * Visual query builder allowing you to build complicated queries without any knowledge of SQL syntax * Multiple SQL editors with code completion and syntax highlight * Large script executing (SQL script editor) * Ability to view query plan as diagram * SQL Formatter (Available from SQL Editor context menu)Report designer with clear in use report construction wizard * New Create Report Wizard allows you to create simple reports in a few clicks * Managing reports the same way as if they were database objects: accessing reports directly through DB Explorer treeImpressive data export and import capabilities * Exporting data to most popular formats: MS Excel, MS Word, HTML, PDF, TXT, CSV, DBF, XML, etc. * Exporting data to MS Access * Importing data from MS Excel, DBF, TXT and CSV * Importing data from MS Access * Bulk Insert wizardVisual Database Designer to handle database structure in a few clicks * Creating diagram of existing database using Reverse engineering tool * Dividing diagram into different subject areas located on separate pages * Navigating through diagram using preview navigation tool * Creating/editing/dropping tables and table fields, visually setting links between them * Saving as image or printing database diagram * Two diagram notations (IDEF1x and IE) * A lot of visual customization optionsEasy-to-use wizards performing SQL Server administrative tasks * Attaching database * Detaching database * Backing up database * Restoring database * Managing backup devices * Managing jobs, alerts and operatorsOther useful tools to make your work with SQL Server as easy as it can be * Extracting metadata into text files or SQL script editor * Powerful print metadata module for creating customizable metadata reports * HTML report generator to create a detailed HTML report about your database quickly * SQL MonitorAnd other useful features * Keyboard templates * To-do list * External tool managerIn-purchase benefits * FREE unlimited Technical Support during 12 months * 50% Major Upgrade discount * FREE Minor software updates * Volume discounts when buying two or more copies of one product * Cross-selling discounts on related productsURL: http://www.sqlmanager.net/products/mssql/managerhttp://rapidshare.com/files/37325154/www.softarchive.netEMS.SQL.Manager.2005.for.SQL.Server.v2.7.0.2-iNViSiBLE.rarPass: www.softarchive.net