SQLExecMS version history

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;