|
Legend : [+] added, [-] removed, [~]changed.
::ver 2.6.0.0
[+] support for SQL Server 2005 features : Schemas, CLR
Objects, Partition Functions, Partition Schemes, Assemblies, DDL
Triggers
[+] ability to start job from any step
[+] option to have Navigator either on left or right side of the
main window
[+] ability to save filed's value into a file in "DataView" and
"Query" window
[~] user interface of "Edit job step" window
[~] user interface of "Find in Objects" window
[~] "Active connections" window now marks all the connections
created by SQLExecMS
[~] user interface of "Security" window to increase speed:
Database access requests by demand only
[-] fixed bug in "Query" window when tool freezes if there
are too many objects in database
[-] fixed bug of improper ordering steps in "Edit Job" window
[-] fixed bug of incorrect script generation related to the
indexes
[-] fixed bug in "Find in Objects" window when database has a
name with spaces
::ver 2.5.0.0
[~] user interface, it's server oriented now instead of
database oriented
[~] Active connections window shows Input Buffer at the bottom
of it
[~] proper support for TEXTIMAGE_ON option
[~] proper handling of columns with spaces inside the name in
script generation
[~] export all grids into text file
[~] BULK INSERT functionality replace by BULK INSERT command
generator
[~] Code Assistant functionality and behavior
[~] Shrink File dialog has more functionality
[-] fixed bug during generation of INSERT script for fields with
spaces in the name
[-] fixed bug related to unique constraints during script
generation
[-] fixed bug related to table functions permissions
[-] fixed bug during granting permissions in DB Users window
when different type of objects selected
[-] fixed bug related to Data View of a tables/View with the
names as a reserved word of T-SQL
[+] support Login look up in Active Directories
[+] library of code
[+] favorites, where objects' bookmarks can be saved
[+] object's security mode in Objects window
[+] open windows tool bar
[+] ability to optimize columns width in Query and DataView
windows
[+] ability to change database context in Query window
[+] ability generate data-time fields in ODBC format during
generation of INSERT script
[+] terminal window
[+] quick access to DB properties on Objects window
[+] ability to review and manage DB access for logins in
Security window
[+] ability to save and load profiles for script generation
[+] ability to generate ready for BULK INSERT scripts
[+] ability to specify batch size during generation INSERT
script
[+] quick search in Objects window
[+] error filter in Error log window
[+] ability to create new Login during creation of a DB user
::ver 2.2.0.0
[~] in order increase the speed
of Query window opening "quick reference" objects are loaded on
demand (first use)
[~] Active Connections window refresh when the time is on made
asynchronous
[~] improved handling of huge volumes during generation of
Insert script
[~] Connect dialog accepts empty string in Server parameter as a
localhost
[~] design and default position of some dialogs to support large
font size
[~] design of Generate script dialog
[~] content of the message tab in Query window navigates to the
top after execution
[~] limited the size of SQL scripts to save in history
[~] default extensions in open/save file dialogs
[~] improved process of database attachment. Information about
transaction log and secondary data file is read from primary
file.
[-] fixed bug during sorting by Avg Page Density in
Fragmentation window
[-] fixed proper handling of some database statuses in Databases
window
[-] other minor bugs
[+] support for maintenance plans
[+] printer setup ability in Print Preview window
[+] ability to edit job's step right from Jobs window without
calling Edit Job dialog
[+] ability to map an existing user in a database to a login in
Security window
[+] ability terminate generation of a script in Generate SQL
script window
[+] ability to select custom font for grids in DataView and
Query windows
[+] option to include "TRUNCATE <table>" into an Insert script
[+] ability to copy users in Security window
[+] start page for easy navigation
[+] status bar in DataView window with total number of records
in currently selected table/view
[+] option to generate N'<value>' constants in Insert script for
char/varchar columns
[+] ability to generate SQL script for database users with
grants and permissions right from Security window
[+] ability to start/stop SQL Agent from jobs window
[+] visual presentation of server's HDD utilization in Space
Utilization and Databases windows
[+] ability to output multiple recordsets into one text panel in
Query window
[+] additional filter options for permissions in Security window
[+] ability to associate .sql files with SQLExecMS
[+] ability to generate script for the jobs in Generate SQL
script dialog
[+] command line parameter for SQL file
[+] dialog confirming the detaching of a database shows number
of active connections to it
::ver 2.1.0.0
[~] user's interface ( MDI
), context menus and many other things
[~] allowed to open more that one search window
[~] additional GO operators added into script
in order to prevent creation of objects with unwanted comments
[~] "Active Connections" windows save and
restore the layout of columns and filter/timer status.
[~] "Active Connections" windows show
total/filtered number of connections
[~] proper handling for hypothetical indexes
(statistics)
[~] update of space usage in "Space
Utilization" window made asynchronous
[~] rebuilding indexes in "Indexes" window made
asynchronous
[-] bug in INSERT INTO script with decimal
values for some regional settings
[-] collation conflict during generation
of a script for users/roles if collation of master DB and your DB is different
[-] some other minor bugs
[-] bug in INSERT INTO
script with TIMESTAPM datatype
[-] inability to delete a
schedule from edit job dialog
[-] incorrect value in
"Scheduled" column in Jobs window, if the job has more than one schedules
[-] some bugs related to
case-sensitive collation
[-] problem
with generation a script while there are two indexes with the same name in the
DB
[+] "Wait
Statistics" window with ability to analyze wait types for SQL Server resources
[+] "SQL History" window to quickly recall
statements that you executed.
[+] trace flags manipulation.
[+] fragmentation info for indexes (SQL 2000
only)
[+] ability to kill blocking connection in
"Active Connections" and "Lock Info" windows
[+] start and stop buttons for scheduled jobs
[+] context menu in "Navigator" and "DataBase
Object" windows
[+] quick access to the list of open windows
[+] select @myparam=, into EXECUTE template for stored procedures and
functions [+] ability to view text returned by
fn_get_sql (SQL2000 SP3 only) in connection properties [+] "Active connections" window shows number of active
transactions of connection. [+] ability to filter
active connections by only those which have open transactions [+] ability to quickly locate object under
cursor in Find in object window [+] ability to parse T-SQL
in "Query" window [+] ability to filter records in "Lock Info"
window [+]
"Changed" indicator in "Query" window, if text has been changed since its last
execution
:: ver 2.0.1.0
[~]proper usage of job categories
during creation/changing jobs
[~]connection to slave server in "SQL Compare"
window, has been fixed
[+]job categories management in "Job" and "Edit
Job" windows
[+]ability to edit object in "Find in objects"
::ver 2.0.0.2
[-] incorrect generation of
a script for Domain/User Defined Data Types when TEXT,IMAGE type is used
[-] incorrect generation of INSERT INTO
script for TEXT, IMAGE fields when their values are NULL.
[-] "XXXX is not a valid date and
time" bug in DataBases window reported for certain regional settings.
[~] the method for showing images in
Extended View window.
::ver 2.0.0.1
[-] " XX.XX is not
valid floating point value for field 'size' " bug, which was reported for some
regional setting.
[~] prohibited to set READONLY property
for PRIMARY file group in New/Edit database window.
[~] enforced checking of identifiers
against reserved keywords and numbers. All such identifiers will be enclosed in
square brackets.
::ver 2.0.0.0
[+] new version has been
released;
|