---------------------------------------- < SQL Stripes Version/Revision History > ---------------------------------------- **************************************************************** *** Please visit http://www.sqlstripes.com for more details. *** **************************************************************** /+------\ |DevLog:| \------+/ Sep 08, 2008 - 2008 Edition (v2.08 Build 900) Released Official support for SQL Server 2008 RTM Added new Alert: Slow Ping (configurable RoundTrip value) Added OS Platform Detection (x86/x64) Added "Recently Connected" group which get the last 10 (max) stripes opened Improved Process viewer Improved Authentication mode detection for instances and linked servers Fixed a bug on alert fix notification Fixed a bug with GO separator inside T-SQL Executor Fixed a bug with adding new servers to a shared repository in a non-latin collation Fixed and Improved Search mechanism Fixed shortcut for Quick Search (Repository) Fixed a bug where removed stripes are still reported during monitoring cycles (had they failed on Ping) Fixed Vista (sp1) and Windows 2008 Detection Fixed Server Edition detection for instances and linked servers Fixed bug on unique column in list Fixed Null value bug on Authentication when using remote repository Agent is assumed N/A on SQLExpress Jun 03, 2008 - 2008 Edition (v2.08 Build 365) Released Fixed Database Properties view from within Search results Fixed Highest CPU process viewer Added WITH (NOLOCK) to table viewer Synonyms can be viewed directly from Search window Added View TOP 100 from Search window Added FileGroup and more accurate database files information Note: There's currently a known limitation of running SQL Stripes as a service under Windows Vista Fixed Databases graph view on multiple servers (the last server was cached) Mar 31, 2008 - 2008 Edition (v2.08 Build 360) Released Added supports for viewing objects & executing queries through Linked Servers “Multiple Search” (Database Object Finder) now supports Linked Servers Added an option to directly assigned opened Stripes to a Group Added Grid/Text results hotkeys for T-SQL Executor (Ctrl-D/T, same as standard) Fixed bug when opening T-SQL Executor directly from a selected database Fixed a bug on multiple search window when opening directly from a selected server/database Fixed Environment variables extraction on UDA (when storing %..% as part of the execution string) Additional Repository enhancements around Drag&Drop & Multiple Selection Fixed Job view/execution for linked servers Fixed Folder Explorer through linked servers Fixed Linked Servers counter UI Enhancements - Overall Mar 17, 2008 - 2008 Edition (v2.08 Build 347) Released Stripes colors (Default, Alert & Focus) are now configurable Fixed Network Browse on an Instanced Server Improved Integration with SQL Server 2008 Enhanced Repository functions Improved Multiple Search mechanism Improved Help Fixed focus on repository items inside the configuration window Various tune-ups to Linked server mode Fixed display for groups with no assigned servers Fixed Group Drag & Drop functionality Jan 31, 2008 - 2008 Edition (v2.08 Build 333) Released Added UDA - User Defined Applications - allowing the user to define & integrate his own applications Added Remote/Shared Repository support - Repository can be stored on an SQL Server and accessed from various instances anywhere Added new Hotkeys for ease of access: F12 for "More" button, Ctrl-F5 for Internal T-SQL Editor Repository Enhancements Repository Database Schema updates Improved Help Improved T-SQL Viewer window syntax Highlighter Added an option to see the highest CPU-Consuming process (within SQL Server) Fixed a minor bug involving extra bracket when viewing a table with Query-Analyzer Fixed other various minor bugs Sep 10, 2007 - v2.00 Build 201 Released Added Authentication mode information (Under Extended server details) Fixed a bug where the task list appeared empty Fixed a small issue on text focus inside the configuration screens Overall performance optimization May 10, 2007 - v2.00 Build 196 Beta Released Fixed a bug where HTML Report reports the incorrect failed job status Added Enable/Disable control for jobs NEW! Jobs window has multiple selected - multiple jobs can be started/stopped/enabled/disable Changed Default email as CDO & HTML Format (otherwise HTML log report is affected) Fixed job enable/disable status May 03, 2007 - v2.00 Build 190 Beta Released NEW: Added Grid control to Query Executor - Grid can contain a combined result from multiple servers - Results can be exported to Excel & XML - Query can use in order to distinct servers inside the grid (i.e. SELECT , * FROM ...) - Results can be quickly sorted * See more in the Help section for usage guidelines! Improved Windows Vista compatibility NEW: Ability to Start/Stop and view status for SQL Server Jobs (directly from SQL Stripes) Servers/Groups can be renamed directly from the main repository window Fixed web update check (www side) T-SQL Window executes selected areas (similar to Query Analyzer) Fixed object viewer compatibility with SQL Server 2005 Fixed Search results compatibility with SQL Server 2005 Preliminary Katmai support (based on April pre-release) Fixed configuration values viewer for SQL Server 2005/Katmai Minor changes on SQL Server 2005 Security guidelines Better Export to XML functionality CPU Alerts are on by default Apr 17, 2007 - v2.00 Build 176 Released Fixed a bug which generates an error when openning Database properties from search window (in some cases) Fixed OS detection bug in Extended Details window Better Repository resizing Added 2005 sp2/gdr1/gdr2 detection (all recently release hotfixes) Mar 20, 2007 - v2.00 Build 170 Released Added support to 2005 sp2 (both releases) Minor design enhancements Repository can be exported to Excel Added additional Data/Log file information (Database Properties->File Details) Improved Status Bar (At the bottom) Timer displays as HH:MM:SS (used to be only in Seconds) HTML Alerts page has a new auto-refresh Timer; This allows browsers to reflect the current status HTML Report format improved Feb 16, 2007 - v2.00 Build 153 Released Added Indicator to stripe when connection has insufficient permissions Added Timeout Settings for internal T-SQL Executor Setup now contains newer Repository database schema Jan 01, 2007 - v2.00 Build 150 Released (Happy New Year!) Added SQL Executor for individual Servers/Databases (a good replacement if SQL Tools are not installed) Improved T-SQL Result display (T-SQL Execute on Opened Stripe Window) Queries separated with "GO" can be executed on the SQL Executor Added Timer to SQL Executor Minor Bugfix Nov 30, 2006 - v2.00 Build 145 Released From the Drives window you can now quickly navigate to Databases reside on the selected drive Added "Maximum SQL Server Memory" to Extended Details Window Fixed long SQL Text which was trimmed in the viewer Fixed CSD Version detection on 2005 Instances Better Focus handling on Dock/Undock Better Tree Selection (while holding Shift) Added OS Detection through SQL Port (Extended Details window) Nov 16, 2006 - v2.00 Build 134 Released Added an option to delete multiple servers ("Yes to all") Fixed Group Assign removal when deleting Server from Repository Improved Stripe State detection on Repository Various UI improvements Help file has been updated Nov 02, 2006 - v2.00 Build 130 Released - 1st Public Release for SQL Stripes v2 Fixed Connect to Group when using a local repository Implemented new feature: Repository Groups Implemented new feature: Distributed Repository (use any database to store the repository. Still experimental) Autohide is disabled when Configuration window is opened Added Detailed Version info when right-clicking version on a Stripe Added an option to extract Connection String from a Stripe Added DBCC INPUTBUFFER for SQL Processes Window Renaming Stripe name in Repository affects the stripe immediately if opened Added User Details window Added Easy Navigation inside each stripe (mouse-over of labels) Sep 15, 2006 - v2.00 Build 100 Fixed port configuration Fixed Version check mechanism Connection manager optimization Speech Alerts Enhancements Better Stealth mode Fixed control lock issue when using "Open without connect" Fixed keyboard selection on SQL Network Browser Aug 29, 2006 - v1.90 Build 1031 Added SQL Server Configuration values window Added an option to Ping a server directly from Repository Fixed a display bug in SQL Processes Fixed Server rename while stripe opened bug Fixed Parent-stripe options called from Databases window Aug 10, 2006 - v1.90 Build 1025 Fixed Service behaviour upon quit/shutdown Fixed various search bugs When Auto-Hide is off, no focus occurs when going over the repository window Jul 11, 2006 - v1.90 Build 1023 Fixed Database Collation detection (when different server default) Fixed Auto-Start Selection Enhanced "Wait" indicator Jul 03, 2006 - v1.90 Build 1018 Repository Auto-Hide switch is now saved Repository can be manually resized Faster Auto-hide process Tray icon now indicates on the refresh progress Fixed timer reset bug Fixed minor memory cleanup in Logger DLL Resolution checker temporarily disabled Jun 27, 2006 - v1.90 Build 1013 Fixed main-menu appearance bug (overriding control bug) Fixed CDO SendMail Bug (occurs when smtp is remote) Some of the new help screen were added Jun 26, 2006 - v1.90 Build 1011 (RC1) *** This is the first PUBLIC Release of v2 beta *** UI Makeover: - New Stripes Repository - Tree view aligned to the left side of the screen - Can be (Auto) Hidden to save workspace - Easy find, tag, marking (including ranges) - New Menus Added Speech Alerts Support (still experimental) Fixed various Search issues Fixed Owner concatenation on object viewer Added simple Indexes view Table preview (TOP 100) can be done on Views as well Applied Autostart functionality on new Repository Monitoring configuration is now part of the main configuration window Fixed a bug with Sorting List by Database Size Fixed openning Repository/MDAC messages (1st run) Fixed Logger class file initialize Improved Auto-Hide Added Job Steps Viewer Added Job History Viewer Added Resolution advisor Plugins are now under the "Main" menu May 15, 2006 - v1.90 Build 945 (private release) Added System Process List (Including the ability to kill task) Added System Information (for each stripe, depends on systeminfo.exe) Added Creation Date column to Object Viewer Fixed Exit bug which sporadically caused SQL Stripes to either stay in memory or display error when quitting Fixed Viewer on Object Dependency tab (object viewer) Faster Object Viewer (loading time) May 01, 2006 - v1.90 Build 900 (private release) Added Mass-Compilation Wizard Added Severity filter to console window Added Network Error detection (upon SQL Connection) Added Text Highlighting to SQL Viewer Enhanced SQL Version detector Fixed Execution from Search Window Fixed "Check Service if Ping Failed" functionality Fixed Direct Search Fixed CPU Alerts Fixed high CPU usage which sometimes occurred while refreshing stripes SQL Connection Engine has better connectivity & lower CPU usage Improved Logger DLL File/Console access Improved Search Engine Mar 20, 2006 - v1.80 Build 165 (beta) - (private release) Added x64 & ia64 Support (64-bit Versions) Added Suspect Databases Alert Added Stripe Visual Styles (Skins) settings Added more connection protocols support Added new stripe option: close all child windows when stripe is closed Added T-SQL Global Search (for example, find a stored procedure code) Added Recent Alerts view to HTML Report Added Table Preview (TOP 100) Added GDI Overflow protection Added option to search inside a database directly from Databases view (right-click) Added /Console support to Remote desktop (configuration window) Added the ability to view Stored Procedures, Functions & Triggers through Linked server Enhanced Stripe design Improved Shrink mechanism On new installation - the default stripe appearance is Stretch mode Fixed stripe resizing issues when using Stretch Fixed Database status indication Tray icons changed Fixed stripe list menu (Opened stripes) Fixed various linked server issues Improved Search & Mass-TSQL Mechanisms Fixed a bug in the logger DLL When running as a service - it is now possible to stop the service through SQL Stripes Fixed Database Owner detection on 2005 /--------------------\ [ Pre Version 2 Devlog ] \--------------------/ -------------------------------------------------------------------------------------------------------------------- Lines above belong to v2.X PRE-RELEASES -------------------------------------------------------------------------------------------------------------------- Jan 01, 2006 - v1.80 Build 115 (beta) Fixed CPU Indicator Dec 21, 2005 - v1.80 Build 110 (beta) Added CPU Indicator (Stripes, Extended Server Details & Alerts) Added Options to load a trace template directly when using Profiler Configuration - Added new logical group to Configuration screen: "SQL Tools Integration" Configuration - Stripes group now contains two branches: Settings & Appearance Fixed instance service state detection Fixed "Auto Detect" Location for SQL Server 2005 Profiler Fixed Refresh on SQL Log Viewer Fixed minor issues with databases containing special characters Table viewer - Enhancements General Design/UI Enhancements Nov 17, 2005 - v1.79 Build 999 (beta) Fixed freeze bug during monitoring mode (occurred after a few running days) HTML Reports - fixed indicator refresh bug Nov 09, 2005 - v1.77 Build 997 (beta) Added Console Windows Optimized memory usage overall minor bugs fix Added an option to view version number instead of description Fixed an error with raising number of disk space alerts Fixed Balloon Tips configuration value Sep 21, 2005 - v1.77 Build 985 (beta) Added Remote Directory Explorer Extended Server Properties - Added Uptime indicator Fixed display of very large tables Object Viewer - Added quick space information (sp_spaceused) Fixed MDB Auto-Repair mechanism Aug 22, 2005 - v1.77 Build 977 (beta) Note: each new release provides a new Trial Period Added Jobs viewer CMD Emulation - better special characters handling Object Viewer - Added quick COUNT(*) option (for tables & views) Object Viewer - Added DBCC switches (for tables) Dialog boxes text can be copied into Clipboard Added IP/DNS Name resolve to opened stripes (right-click name/ip) Process viewer - Added Output Buffer view Repository - Auto Start selection is now represented in the server's icon Repository - Auto Start selection can be changed directly from Repository Window (right-click) Added Duplicate repository entries wizard (DNS that already exists as IP and vice versa) Fixed detection for Profiler on SQL Server 2005 Database properties - Added Database mode HTML Report - Added IP Field Jul 27, 2005 - v1.77 Build 952 (beta) When monitoring - HTML Report will be update even when there are no alert Remote Desktop has been Enhanced Improved graphics design Added multiple selection support in Search & Object viewer windows CMD Emulation: Added option to Abort Execution Added option to Stop All running Traces (on Server Properties) Disk space procedure is faster (not being recompiled if already exists) Enhancements were made to the 'Extended Server Details' screen Added option to close all Inactive stripes (not connected to a server) Jun 30, 2005 - v1.77 Build 920 (beta) Added Users Search Added Jobs Search Improved search mechanism HTML Report - Added 'Notes' field HTML Report - Added warning colors to critical alerts Added system processes to process list, can be excluded Minor Enhancements & Optimization Jun 09, 2005 - v1.77 Build 907 (beta) SQL Server 2005 Support - Major components updated for full compatibility Added full integration with SQL 2005 Management Studio (similar to the one with Query Analyzer) Added SQL Server 2000 sp4 detection & support Added new alert type: Login Failed - on which a user will be warned that server cannot be monitored Improved design for Email Alerts (when using color/html) Added new Compression Method: Extensive (shrinks each file individually) Faster connection management & response time Added new Sort type - By SQL Service Status Fixed some rare cases where instead of service down a 'Login Failed' was reported Fixed Scroller on HD List (when more than 3 drives exist) Minor changes to stripe design, movement speed, menus Object dependencies can be viewed directly Apr 19, 2005 - v1.75 Build 800 Added Mass Query Executor (can run any T-SQL on all opened stripes) Stronger SQL Server 2005 Support Added Estimated Table size to Table List Added /SQLMode(1-3) to enforce SQL Connection Type Added new switch to disable XP/2003 style menus Small fix on /CheckOnce parameter Help File has been updated Added Fit to Screen stripe mode (extra option to alignment selection) Fixed Server Timezone detection Extended Server details menu appears on the main Stripe menu Copy to Clipboard is possible for Extended Server Data Fixed name display on Extended Server Details Feb 24, 2005 - v1.75 Build 750 Drag & Drop support from SQL Server Repository window into workspace Data file is automatically being compressed when required Feb 17, 2005 - v1.70 RC2 (Build 718) Missing HTML File was added to setup - Generate HTML will now work Fixed User list Query Object Definitions (such as table design, stored procedure input variables) can be displayed Added Stripe Alignment T-SQL Editor has syntax highlighting Added Stripes Highlighting (Current themes: Default, Alert & Focus) Fixed SQL Server version on an instance HTML Report is now enabled Fixed Invalid License Scenario (can now re-enter new valid license) Double-Clicking drive inside a Stripe will open a command shell to the selected drive Menu DLL Updated Feb 03, 2005 - v1.70 RC1 (Build 701) (beta, RC1) -- Major Changes: Added Integration with SQL Profiler Added Syntax Colors to SQL Object Viewer HTML Reports can be Automatically Generated when monitoring servers (Autmode) When opening a View, both Design and Result windows are shown Added Search option inside Object Viewer (for T-SQL code) Major UI Enhancements Fixed Failed Jobs Query - will not show individual failed steps if general job result is success -- Minor Changes: Added more details to Failed Jobs list Stripe Menus changes - More options are now available directly through the "More" button on each stripe. Fixed an exit-crash bug when using the Tray Icon Fixed a small bug where the process kept running after quitting the application Tray result indicator will not be changed if not on Auto Mode Improved 'Put' command performance Empty Server list Dialog message has been replaced Help file has been updated Added colors to Process list for easier type distinction Added 'Number Of Traces' to Extended Server Details Window Fixed SQL-DMO installation/removal on setup script Jan 10, 2005 - v1.50 Build 230 (beta) Improved Search Window design Added File Import to license screen Fixed License Error message when using some special characters Icon View for search results is now available Stability problem fixed Added Stripe List Dropdown Menu Fixed Keyboard buffer bug Fixed SQL Process connection leak Process Viewer - Database name is now included Process Viewer - Multiple Processes can be selected & killed UI Enhancements Dec 20, 2004 - v1.50 Build 201 (beta) Major Design Enhancements Imporved Server List Chooser Added Resolve Selected/All IP's to Server list window Enhancements on Configuration Window Added option to view Object Dependencies Table Viewer/Editor Enhancements Fixed a minor Tray Icon issue Added Balloon Tips support (optional) Console Window can be opened by right-clicking on the Stripe's Selected Hard-Drive and the physical file on File Information Fixed a bug when trying to Search for Database object on Local machine Added Clear/Save buttons to CMD Emulation Improved Get/Put on CMD Emulation Added option to automatically delete files from FTP after transfer (Get/Put) Fixed Multiple filegroups space information Nov 09, 2004 - v1.00 Build 110 Fixed Disk Space OK Notification Added Special Characters support HTML Report can be viewed instantly when created Object Viewer Enhancements Added Drive Data on Linked Servers Added Owner Table info to Trigger List Oct 15, 2004 - v1.00 Build 100 Added option to Exclude Existing servers from "Add New" List Quick Server Tag is now also IP sensitive Few help fixes ________ END OF BETA STAGE FOR Versions 0.X _______________________ Sep 27, 2004 - v0.95 Build 200 Fixed an Error where Canceled Jobs where reported as failed Hotkeys fixes Sep 07, 2004 - v0.95 Build 100 Fixed a bug on Search Window UI improvements Aug 17, 2004 - v0.90 Build 990 Fixed Error message when Object Viewer window was maximized Improved Table Loader/Viewer (can be canceled) Better Keyboard shortcuts Fixed a small bug on the Object Finder loader Preventing Duplicate Instances on Stripes' 'Children' Added "Total RAM" to Stripe - replacing Connection Protocol Aug 09, 2004 - v0.90 Build 980 Added Quick Search & Tag for Server List Window Fixed Failed jobs notification (was always on) Added missing images to Help file Connection Protocol is now set to Auto by Default (was TCP/IP) Fixed MDAC/DMO Warning notification Added 'Stop' to Search Window Added Number Of Processors data to Server Properties Fixed a problem with "Root Drive" monitoring option Email header changed to "SQL Stripes Alerts/Notifications" Failed Job name will be included on the email alert Preliminary Yukon (beta 2) support Free Disk Space alert notification is now configurable (addition to %) Added /Repair switch in order to Compact & Repair SQL Stripes Database SQL Server connection Timeout is now configurable Overall Bug fix Jul 26, 2004 - v0.90 Build 970 Fixed Tray icon disappearance Help has been updated Fixed various search issues Fixed Refresh Conflict issue Added Port box on Server Configuration (not part of server name anymore) Stripes UI Enhancements Jul 21, 2004 - v0.90 Build 950 New & Improved Stripes design Added Database Search for Object Finder window System objects can now be filtered (Search Window) Modified Connection Timeout settings Log files split - SQLStripes.log & Alerts.log Logs are now located under .\Logs folder Improved various Error handling Jul 13, 2004 - v0.90 Build 920 Added option to save opened stripes as selection Fixed "No Opened Stripes" error message Fixed Tray Icon issue Added Wildcard switch to search window Added Indicator (Progress Bar) when loading stripes on the first time Search Results can be exported to Excel Fixed Tray Icon notification behavior Number of Alerts will now appear in the Tray Icon Tooltip Fixed missing DNS data on first round Changed Alerting concept - can be activated with no email notification. Fixed email format on CDO/Plain-text Added Data/Log Maximum file size restriction (to Database Properties) overall bug fix Jun 30, 2004 - v0.90 Build 900 SQL Stripes can now run as a Service (Can be controlled through Start Menu) Added Object Search (for all opened stripes) Added HTML Format support to mail alerts Added SQL Log Viewer (Under Advanced menu) Fixed Data File size display Extended support for Linked Servers Added Trigger Viewer/Browser Added Microsoft CDO (Collaborative Data Object) Mail Support (Choice to SMTP) Added SMTP indicator to ensure email has been sent on /checkonce mode. Fixed an error with SQL Alerts sent when prior tests had failed Opened stripes are automatically updated on configuration changes Added Linked Servers Window Fixed a small bug in SQL Server Tree Display Fixed an error while trying to count functions on SQL Server 7 and below Fixed display of system/extended Stored Procedures & Functions Added option to Truncate Log from Database Properties window Added "Last Protocol" for connection protocol Officially supporting MSDE Fixed Number of Linked servers for a linked server Added General Backup Report Various Fixes on Backup Display Changed "SQL Agent Jobs" to "Backup Jobs" in mail alert to distinct from Agent Service Fixed Tray window issue Changing Server name while stripe is opened will not affect test UI Design Enhancements Help has been updated Web site has been updated Added option to delete objects (Tables, views etc...) from Object Viewer Added Option to Kill Task from Processes Window May 27, 2004 - v0.90 Build 800 Added VNC4 Support Design Enhancements More improvements to core SQL Classes Export to Excel is better and faster Fixed Help issue causing Application to crash in some cases Added Extended Database Properties window Added SQL Connection test on Configuration window Added Unsaved Data confirmation in Configuration Various Linked Servers connections has been fixed Fixed an issue failing to Launch Query Analyzer in some cases Fixed User List Window MSXML is no longer required by SQL Stripes May 18, 2004 - v0.90 Build 700 Fixed Email Alerts Logic Minor UI Changes/Fixes Added customized Email message (attached to each alert) Fixed some log file issues Higher Timeout value on SQL Service check Refresh all cannot be launched when already in a process Fixed Registry bug when setting Null values Added Extended Server Information Window Version can now distinct between sp3 and sp3a Added Internal Cache for faster stripes load/refresh May 03, 2004 - v0.90 Build 600 Added Invalid Database to Stripes indicator Fixed a bug where Login failed was reported instead of Service Down Fixed a bug with editing the Notes field (on Server Configuration) Fixed an email reporting bug Fixed a bug where AutoStart did not send alerts on the 1st run Fixed Server Name on Email Report Added option to Browse Server (Explorer) Apr 28, 2004 - v0.90 Build 500 Updated setup with newer DLL's Some icons were fixed Minor fix on 'Login Failed' Detection Agent service is not tested if Login has failed Help has been updated Apr 01, 2004 - v0.90 Build 400 Added Alert option to SQL Server Agent Fixed 'Login Failed' Status Added new method to check Database & Root drives only Added option to launch Enterprise Manager directly from SQL Stripes (partial integration) Added Cluster Indicator on Stripe Mar 29, 2004 - v0.90 Build 300 Added Customized View for Main Server Window Added Sort: by Ping Result (Under opened stripes menu) Added Customized icons for Database status Improved Tables/Views window Added Stored Procedures & Functions Viewer Added Notes field for each server UI Enhancements - Overall Fixed Bad Jobs Report - Including last_run_date Mar 23, 2004 - v0.90 Build 200 New Alerts mechanism (email alerts) is now in place with the following changes: - Alerts are only sent once (per problem) - When problem is fixed (for example - SQL Service is up) an 'OK' message is sent - Duration of problem has been added Fixed bug reporting disabled failed jobs Added configurable low-disk space percent parameter Fixed some minor System tray issues Added option to delete servers from Server List Window When a server is deleted - relevant stripes will be closed. Fixed Stripes sort Mar 16, 2004 - v0.90 Build 100 Improved Help Fixed Failed Jobs mechanism. (Now shows Job name, Failed step T-SQL) Menu/UI improvements Mar 12, 2004 - v0.80 Build 900 Added full compatibility with case sensitive (Binary) SQL Servers Added Customized commands to CMD Emulator Fixed some compatibility issues with CMD Emulator Fixed Default value for Disk Space check Fixed server update issues on machines with non-English as default language Mar 01, 2004 - v0.80 Build 800 Fixed 'Failed Jobs' display Added Server Selection presets (can be loaded & saved) for /Autostart mode Added Users list per Database Added Total Disk size to Stripes Fixed an error when server is set to Binary sort order Added intervention (Cancel) button to stop stripes process Fixed a bug with the Tray Icon notification Added Load/Save Selection keys to Server List Window Fixed issue with storing blank passwords Feb 19, 2004 - v0.80 Build 700 Better speed on Database window + Indicator Added option to Shrink Database from Databases window Web site is back online with a new design Version check engine updated Jan 05, 2004 - v0.80 Build 600 Added Remote Desktop Support Changed field sizes on data file Added indicator / alert when server list is empty Fixed a crash bug when setting alert time to 0 Fixed some Export to Excel issues Added direct help on 'Add new Server' screen Some code optimization Dec 15, 2003 - v0.80 Build 500 The FROM address is now customized (alerts) Fixed Terminal Services stability Added Full Screen mode to Terminal Services (see configuration) Added log file splitter to avoid slow log process Faster stripe test Less CPU usage on test, prevents from delaying other running tasks Check for Update feature is restored Oct 16, 2003 - v0.80 Build 400 Fixed "Invalid Use of Null" error message Better Error handling More improvements to help Changed the failed jobs mechanism to be more accurate (looking for last failed jobs rather than for jobs on a specific date) Fixed Auto-Minimize issue Web update distinguishes between no connection and disabled service General stability bug fix Oct 13, 2003 - v0.80 Build 300 Fixed an issue of help not being displayed in some cases Added Uninstall icon to Program group New website design (see http://stripes.docmusic.com) Password are encrypted by default (note: data file is replaced on installation) Configuration window papers on taskbar Added more help Oct 06, 2003 - v0.80 Build 200 All alerts are written into a log file Fixed another SQL-SMO registration issue Added Disclaimer dialog to setup New and improved HELP Sep 25, 2003 - v0.80 Build 100 Added Jobs Status Indicator/Alert to Stripe Added Option to see all failed jobs on a server level (Configurable) Data file will not be uninstalled; you can keep it along the versions Fixed Check For Upgrade Error Fixed Database Size Graph Fixed some Keyboard Shortcuts Stripe Design is a bit wider (will still fit in 1024x768) Added MSXML4 Detection Note: Microsoft XML Parser v4 is now required (included in Setup) Sep 23, 2003 - v0.70b Build 900 Added option to show ALL Hard drives on the SQL Machine Added Hard disk used space & % Free (See special note about this feature) Added "Check Now" option to Tray menu Fixed Check for Update mechanism (server side) Drive Space detection is faster Drive will be marked in RED if free space < 15% or < 500mb Added Alerts notification for low disk space Clicking the Auto-Alerts Timer will popup a Enable/Disable/Setup menu Aug 11, 2003 - v0.70b Build 800 Fixed crash when trying to import to Excel and it is not installed Fixed issue where Setup screen did not load in some cases More fixes to the setup script, SQL-DMO is now installed on all tested machines Added MDAC Version detection notice (below 2.6 SQL-DMO will not work well) Added /StartMinimuzed command line to start SQL Stripes on system tray only (When using AutoStart) Email Alert now includes [Username@Machine_Name] in the "From" field MDAC/SQL-DMO Alerts can now be ignored on Startup Aug 06, 2003 - v0.70b Build 750 Fixed Export to Excel illegal Filename issue Enterprise Manager Support - Added option to quickly add servers listed in your local Enterprise Manager Fixed /Runonce email notification Fixed the /? Screen Added delay on RunOnce mode to allow alert Tray Icon changes according to alerts in AutoMode Fixed crash bug when saving setup (happened if VNC was not detected) Fixed another setup issue of not registering sqldmo.dll Aug 04, 2003 - v0.70b Build 600 Added Customized VNC Location (you can now work with VNC variations such as TightVNC etc...) Added /CheckOnce parameter to run a test on selected servers, send alerts and quit. (This is good if you choose to work with an external scheduler) Removed time limit between Auto-Checks, changed time set interface. Fixed a big where using AutoStart did not send alerts on first run Stripes now also monitors log files drives when located on a different hard drives. Added "Export To Excel" in various windows. Can be minimized to System Tray Uninstalling SQL Stripes will not affect Enterprise manager if installed on the same machine June 18, 2003 - v0.70b Build 500 Setup - All DLLs are now put in a special folder to avoid all possible conflicts Auto Refresh UI was moved to the bottom of the screen (avoiding Menu bug) Initial Help has been implemented Backup check flag also counts Transaction Log Backups (Databases Window) Added Maintenance Backup Plan window Overall bug fix June 10, 2003 - v0.70b Build 400 Added Time Zone Detection (GMT) Added ability to Start/Stop SQL Server Agent through Stripe (Right click on Agent Indicator Icon) Added /AutoStart mode - Start with selected servers' stripes Another fix to Database Status All known setup issues have been fixed By Default, If Ping Fails - SQL Service will not be checked (Configurable) Added /? To get list of available parameters Note: Database structure has been modified June 02, 2003 - v0.60b Build 300 IP is displayed in stripe Stripe now has Red Background if either ping or SQL fails Added Sound notification to Auto Alerts Improved Alerts Setup (Auto Alerts) Added Apply option to setup dialogs Added Backup indicator to Databases Window (Whether a Job exists) Better detection of Database Status May 23, 2003 - v0.60b Build 200 AutoMode Settings are now preserved Better error handling Database related options are now disabled if Login fails Added Refresh button on internal Table Editor Added SQL Server Agent indicator Added Backup Jobs Details Terms Change: "Options" is now "More", "Extended Details" is now "Databases" Database size will use both "mb" and "gb" Added Database Owner to Databases Window Rewrote the Method to Get the Databases List, should solve most of the Errors Added Database Status (Online, Offline, Loading etc...) Added Database Free Space Added Views List / Viewer Added "Resolve IP" option Notice is given if SQL-DMO is not installed (will result in missing functionalities) May 19, 2003 - v0.50b Build 190 Overall bug fix Added Named Pipes Support Minor design change on Stripes (Protocol is now included) Faster SQL Connection Status Optimized SQL Connection handling Added Database Processes List Installation - SQLDMO files will shared DLLs will not be uninstalled May 14, 2003 - v0.50b Build 180 Added Connection status (Status Bar) Added Sort option for Opened Stripes (by Server Name, Asc/Desc) Added Query Analyzer support (Directly to selected Database/Table) Added Automatic Version check (on Startup) PCA/TS/VNC will ignore [/Instance] if part of the server IP Fixed Memory problem when running from command line. Query Analyzer & Download Folders are now customizable through Setup Auto Refresh values extended to 300 Seconds (5 minutes) May 08, 2003 - v0.50b Build 170 Linked server name is now taken from the 'Server IP' field. Fixed Windows Transparency bug Added SQL Editor to table viewer (customize your view) Added Roundtrip (ms) value near Ping status, Along with color based status SQL Server 7 sp2 not shown as '7.00.842' anymore Cluster/Active Instance Aware More data under [Extended Database Information] Number of opened stripes is mentioned in top menu [Control Panel] window is now resizable Readme & History are now two separate files, both accessible from Help menu Apr 30, 2003 - v0.50b Build 160 Added option to include/exclude system tables from Table List Window. Fixed "Del" behavior on Setup Window Added SMTP Alerts support for Ping/SQL Service Fixed setup crash bug when server list is empty Fixed DNS resolve issue on first run. Added option to edit server from stripe Added 'List Available Servers' option when adding a new server Fixed free space issue in some cases with SQL Server 7.0 Ability to ping virtual instances (ServerName\InstanceName) Added to setup: Remember window position and configurable Background color SQLDMO is now installed correctly Email Alerts will not be sent if Login Fails Various UI Fixes Added Quick Apr 23, 2003 - v0.50b Build 150 Added Web Update option Terminal Services auto-username is now configurable. Added Windows Authentication Support Better error handling Icons added to Setup window Apr 18, 2003 - v0.50b Build 140 - 1st Public Beta Release First initial Release 0.50b Build 140 Setup is ready! Web Page is Ready (http://stripes.docmusic.com) Added Table Owner to table list View table uses owner prefix rather than default dbo Fixed table viewer, added customized menu Added Graphic View of Databases (Pie & 2/3D Bar) Added Table List Window Added ability to view tables Started preparations for Setup - initial release. Added Debug.Mode. To enable, say, "I'm Stupid" to the microphone, you must have TTS Engine installed. Moved FTP Setup to Registry / Password is now encrypted. Added Add/Remove Server to Setup (also right-click from Servers window) After quitting setup - Control Panel will refresh InitConnection differs between Ping and SQL Fail If SQL is dead, PCA/TS/VNC are still enabled If SQL is dead, GetNetName is not being used to save timeouts Added Preset to SQL Backup folder Setup/Configuration: +General +FTP +Add/Remove Servers from tree +Modify Servers Data +SMTP +Terminal Services +Special Effects (2y!!) Yet another improvement to the directory interface on CMD Added primitive support to MySQL - still on debugging. when typing in the shell output - auto buffering into cmd text Better directory handling on CMD Emulator. Added Presets menu to CMD, supports quick jump to: Data Folder Backup Folder Cd .., cd in general adds double quotes to handle long names. Added VNC Connection support Better support for linked databases. Note: PCA/TS/VNC will connect to the 'Linked From' server. Fixed a small bug that caused Console window to crash on Minimize Added alpha support for linked servers (firewall detour) Fixed SQL Status detection on server down. Recognizes SQL Server 2000 sp3 Code Reorganization (Global Libs/Classes) Fixed small bug in 'type' command on Console Design Enhancements Better Scrollbar for Automode Applied better Stripe placement method Fixed Always-On Focus bug Applied new Stripes design If Stripe is already opened, a focus notice is given. (Right border)