========================================================================================== Change List SQL Sentry Build 5.5.40 Date: 19/MAR/2010 ========================================================================================== FIXES: Id Component Name 2706 General All chart context menus appear correctly in PA for SSAS when only the SSAS instance is watched 2676 General Improved the message received when adding a SQL Server connection in another domain without using a FQDN 2680 PA-Blocking Fixed a problem where fnGetSQL_20 was not being created on SQL Server 2000 SP3 Build 760 2685 PA-Blocking Block chain messages will no longer report inaccurate duration 2360 PA-Dashboard Corrected the user Exception: 'Axis Object - Auto Interval doesn’t have proper value' 2632 PA-Dashboard Timeouts encountered while the dashboard loads will no longer cause charting exceptions 2707 PA-Dashboard When jumping to the PA dashboard from the calendar view, "Sample" is now shown on the toolbar button instead of "History" 2679 PA-Disk Corrected an issue where controllers did not always show activity over the applicable range 2682 PA-Disk Removed an invalid option in the context menu on the Disk Space and Disk Activity tabs 2710 PA-Overview Updated the PA overview to display device as 'Offline' only when all SQL Server Instances on that device are offline 2709 PA-Overview The colors shown for a device are now consistent with the grid display in PA overview 2696 PA-Overview The context menu option for the PA Overview will now only be activated when the group has devices registered to it 2686 PA-Overview Fixed the calculation for IOps values that caused them to always display 0 2689 PA-Overview Fixed the scrollbar functionality when changing views in PA overview 2692 PA-Overview Corrected a problem where filter criteria would not always apply correctly after a screen refresh and were intermittently hidden from user as a result 2693 PA-Overview Changed the control used for the 'Show Avg Over' combo box to be consistent with the 'Show' combo box 2695 Printing Printing the calendar view works correctly now from the print preview screen and on AMD64 processors 2672 Printing Corrected the print preview window functionality for Runtime Graphs 2691 Printing Fixed the problem printing landscape layout of event chain diagrams on AMD64 processors 2697 Reports Parameters are no longer disabled when refreshing or running a saved report, even if the previous parameter is no longer available 2694 Reports Updated the language setting to correct the format for date parameters in PA reports 2687 Reports Descriptions for reports uploaded to SSRS are now consistent 2688 Reports The SQLDS data source's authentication type was changed to “Windows integrated security” from “Credentials supplied by user” to avoid login prompts when running reports 2711 Toolbar Corrected a problem with the time selector in the navigation toolbar where some values were truncated 2714 Toolbar Pressing the tab key while on the end time control no longer causes the active tab to change ========================================================================================== Change List SQL Sentry Build 5.5.30 (Release Candidate) Date: 19/FEB/2010 ========================================================================================== FEATURES: Id Component Name 699 Documentation Updated the 'Watch Additional Connections' topic in the Quick Start Guide to include Performance Advisor details 651 General Added a remote desktop connection option to the SQL Sentry console's help menu for support and consulting services 695 PA-QuickTrace QuickTrace detail rows can now be resized, and text can now be copied from the Text Data column ========================================================================================== FIXES: Id Component Name 2638 Chaining All relevant information is now viewable upon opening the Event Chain editor 2642 General Fixed an instance of the user exception: 'The data is not valid' 2646 General The SQL Sentry database connection form has been enlarged to display the caption correctly 2650 General The Date selection display no longer disappears if the DateTime picker is in date selection mode and the time changes due to auto-refresh 2662 General The service configuration utility should no longer crash when changing accounts 2661 Navigator Registering a connection will now function correctly when only SQL Server 2000 is installed 2645 Obj.-Settings The First setting type category will now be selected by default 2652 Obj.-Settings Corrected the drop down menu options for Maintenance Plan settings 2669 PA-Disk The grid now remains hidden on reload if the user has hidden it with the splitter control 2666 Reports Fixed a problem where an invalid symbol in the filename would cause an error when deploying reports 2654 Server-Settings Tab text now correctly changes (displaying a '*') indicating whether the document has unsaved changes 2653 Setup The NSIS based setup detection in Windows Installer based setup package works correctly now on Windows Server 2003 x64 edition 2660 Setup Fixed an installation problem involving the use of SQL Server Authentication for the Windows Installer based setup package 2663 Setup The console can now be installed on Windows 6.0 and higher when using a local user account with default membership 2664 Setup Corrected the message displayed when the 'Test' button is used on the Database Account Information form and only SQL Server 2000 is installed 2670 Setup Upgrading from version 5.1 now functions correctly on case sensitive servers ========================================================================================== Change List SQL Sentry Build 5.5.21 (beta) Date: 29/JAN/2010 ========================================================================================== FEATURES: Id Component Name 657 Alerting Emails are no longer sent for hidden Top SQL 653 Chaining Alert the user when disabling a job that participates in a chain 684 General Assign SSAS trace 'Error' event to corresponding command 672 General Redesigned console alert notifications 671 General Redesigned wizards, with resize support 664 General Updated all grids to be inline with PA grid style 676 Graphs-Perf. Redesigned Event Manager performance graphs 675 Graphs-Runtime Redesigned Event Manager runtime charts 647 Licensing Include expiration dates in Help > About for non-perpetual licenses 677 MDI MDI tabs can now be reordered. 681 Navigator Prompt to unwatch connection when deleting it in the Navigator 661 Obj.-Settings Persist active setting type category and setting type when changing objects, if setting is still applicable 632 PA-Deadlocks Deadlocks graph contains sizing context menus 643 PA-Disk NTFS Mount Points are displayed in the PA disk views 660 PA-Top SQL Added host name support for SSAS Top Commands 689 PA-Top SQL Auto-refresh Top SQL when changing sort 683 PA-Top SQL Log MDX queries that were running when a server went offline to the database as Query Cancelled 674 Printing More printing options are available when printing grids 669 Server-Service History monitor engine threading optimizations to minimize possibility of collection delays affecting chaining, etc. 668 Server-Service Optimized default threading model with lower overhead 670 Server-Service Watchdog thread for monitoring service health 693 User Guide Clarification in Documentation regarding Task Scheduler functionality ========================================================================================== FIXES: Id Component Name 2511 Alerting Format of object created/deleted messages was corrected to be inline with other messages 2583 Auditing Audit messages are generated now when unwatching with PA 1511 Auditing Audit messages for 'Monitor Flag Changed' are no longer generated for tasks that are not monitored 1757 Calendar view The duration field on the job popup was corrected for jobs w/ 00:00:00 average duration that run longer than the average 1904 Calendar view The Start time was corrected for jobs that run SSIS Packages and now appear correctly on the calendar while they are executing 2267 Calendar view Data is now displayed on calendar when start time is between 1am and 2am on the day of DST fall back change 2374 Calendar view The 'Jump To-> Instance' from the context menu was corrected to always use an applicable interval for jobs longer than 10 minutes 2502 Calendar view Oracle EM Backup jobs were corrected to always show up in calendar history with step details 2595 Calendar view Corrected flickering tooltip problem when hovering over time on calendar event 2620 Calendar view Output text is now displayed for all step callouts 2606 Cal/List view Fixed issue where Task Scheduler events exceeding the duration set in user preferences would not show up in the all-day event area 2582 Cal/List view Historical events in the all day area are now included in the list view 2382 Cal/List view Clicking 'Go' after changing the view time/date changes the interval to 1 hour if the time is on the same date and leaves interval as is on another date 2503 Chaining Popup for Oracle Scheduler job now displays correctly when part of a chain 1734 Chaining Updated chain validations to ensure all nodes are linked before saving (user receives message if not) 2593 Chaining The user can now stop watching a connection with PA that has chain nodes without disabling the chain if it is still watched with EM 1073 Filter Changed the order of Review Status entries and corrected And/Or combo boxes for Run Status and Review Status 2603 Filter Remove Filter button is now active after a filter is set in custom views 1719 General Removed the kill action from chain that contains a node that does not support kill/stop, and from the node itself 2228 General Corrected problems with non-default resolutions (120 DPI for instance) that caused label overlapping and truncation 2556 General Removed unused databound properties from the Reporting Services accessor object 2495 General Change made to SQL Server Agent Log error and warning condition messages for clarity 2611 General Corrected problem where the 'ORA-01426' Oracle Error could cause synchronization failure 2629 General Corrected display of combo box when editing 'Output Content Match' condition if there are are more than two criteria 2634 General Oracle Enterprise Manager jobs that contain a blackout period (such as backup jobs) are no longer left in a running state forever after the blackout 2586 General User credentials were corrected to persist once they are updated from Server Service Connection Properties 2597 General Fixed exeption that was received if the Quick Trace window was closed before completion 2599 General Ignored Console Alerts no longer notify user throughout session 2563 General The format of the message boxes with hard line breaks were corrected to be inline with the others 2571 General Fixed an issue where registering a previously registered connection would not use new authentication settings if they were changed 2574 General Fixed and instance of the exception 'Object reference not set to an instance of an object' 2519 Licensing Licenses with cultural symbols no longer return an error when applied 1763 List view Fixed the copy/paste functionality from list view to clipboard 1764 List view The remove filter button is enabled now if a filter is applied to an individual object in history list view 1903 Logs Exporting Data from Logs now includes the Message 2497 Navigator Message given to user if 'Group By' option is selected for SSRS reports if there are no values for Category/Owner 2474 Navigator User is no longer prompted to launch SSMS if SSMS is already running 2616 Objects-Cond. Corrected Output Content Match so that it works for any sources 2625 Objects-Cond. Corrected Edit button visibility in Output Content Match section of Actions pane when the pane width is small 2633 Objects-Prop. Task Scheduler version 1.0 can now be used on 64-bit systems 2605 PA-Dashboard Date ranges larger than 3 years no longer cause timeouts on the PA dashboard 2596 PA-Dashboard Fixed metrics/reports for SSAS dimension cache lookups and dimension cache hit ratio calculations 2557 PA-Dashboard Removed invalid Performance Advisor Dashboard context menu options when the only watched connection is Analysis Services 2580 PA-Deadlocks Correction made to prevent Deadlock grid from resetting while viewing a deadlock in auto-refresh mode 2581 PA-Disk Removed grouping panel from disk activity/space view 2559 PA-Disk Database tooltips now work correctly when there are offline databases 2562 PA-Disk Disk Activity Tab no longer shows Used (MB) and Used % columns 2498 PA-Disk Corrected issue where incorrect Bytes/IO metrics were being displayed on database file tooltip 2500 PA-Disk Removed invalid columns from disk activity and disk space column choosers 2507 PA-Disk SQL Files on unwatched servers no longer show up in disk view in Performance Advisor 2604 PA-General Performance Advisor rollup/purge process failures now alert user 2589 PA-General Fixed an exception thrown if an adapter instance name contains a single quote 2630 PA-General Errors that occurred during the loading of any Performance Advisor tab that were shown as a message box are now shown on status bar 2628 PA-QuickTrace QuickTrace row Logout Time and Login Time columns no longer show the same value 2578 PA-Top SQL Corrected problem with Top SQL Reads, Writes, and CPU filters using higher thresholds internally than set in the UI on 2005 and higher 2226 PA-Win Proc. Updated timeout message when Windows Processes cannot be seen due to high CPU utilization 2450 Perf. Monitor Performance Counters are no longer deleted from custom views when applying a new filter which has no monitorable objects 2577 Perf. Monitor Fixed performance data collection for a counter attached to a job or view and the counter settings are not changed 2541 Printing Corrected printing menu options of the file menu when printing an event chain diagram 1209 Queuing When a job is actively being Queued, it remains on the future calendar 1837 Server-Service Step Failure notifications can now be processed before a job has completed 2552 Server-Service We no longer try to use WMI to check for the running service once a SQL Server authentication has been specified 2588 Server-Service Corrected a rare three resource deadlock situation that could occur in the SQL Sentry Server Service 68 Setup No longer prompt to remove entire application when adding the console to a server that already has a mgmt engine service 2626 Watching Corrected problem that caused warning message 'Possible date calculation spin for Schedule' to be displayed in the SQL Agent Log after watching a server ========================================================================================== Change List SQL Sentry Build 5.1.26 Date: 03/NOV/2009 ========================================================================================== FEATURES: ID Component Name 658 Documentation Added details in Event Sources > Windows Tasks about OS requirements regarding Task Scheduler 2.0 ========================================================================================== FIXES: ID Component Name 2501 Chaining Deadlock occurrence related to chaining was corrected 2569 General Exception: Unable to cast object of type 'Intercerve.SqlSentry'... 2572 General Exception: Axis Object - The minimum value of the axis is.... 2565 Navigator On all editions of SQL Server 2008, registered servers now appear 2401 PA-Dashboard Date conversion problem that keeps dashboard data rollups from running was corrected 2553 PA-Dashboard Setting Performance Monitor Collection interval no longer affects Performance Advisor 2561 PA-Dashboard Dashboard status no longer alternates between errors and no errors 2545 PA-General Top Queries and Average Time data collection always resumes 2543 PA-QuickTrace QuickTrace actions now run even if a previous QuickTrace never completed 2528 Queuing Prefixed the Queue Manager job description with "While enabled" 2477 Remote Procs Optimized SQL Server Agent log read procedure 2540 Server-Connections Remote connections always recover gracefully after the remote server is restarted ========================================================================================== Change List SQL Sentry Build 5.1.19 Date: 02/OCT/2009 ========================================================================================== FIXES: ID Component Name 2061 General Fixed some issues with console window layouts and the reset layout menu command 2551 Server-Service The server service could fail to initialize when the encrypted connection string was persisted ========================================================================================== Change List SQL Sentry Build 5.1.17 Date: 21/SEP/2009 ========================================================================================== FIXES: ID Component Name 2538 General Exception: Value cannot be null. Parameter name: timeString ========================================================================================== Change List SQL Sentry Build 5.1.15 Date: 17/SEP/2009 ========================================================================================== FEATURES: ID Component Name 649 General Change Oracle provider to use ODP.NET (Oracle Data Provider for .NET) 645 Navigator Add a tooltip that displays current status information for connections in the navigator pane 652 PA-Blocking Display used space in the tooltips for database files on the Disk Space tab ========================================================================================== FIXES: ID Component Name 0000 General We've corrected 20+ defects that were submitted through our automated exception reporting system 2448 Alerting Runtime alerts are no longer generated for the first run of a task (before average duration has been calculated) 2244 Alerting Block duration messages now specify the threshold setting in the message 2486 Calendar view The Event Manager calendar will now render properly in 120 DPI 2496 Calendar view The Event Manager calendar will no longer allow you to scroll down too far using the mouse wheel 2529 Calendar/List View The Event Manager Calendar will no longer remain empty if the user is a member of the deny_eventchain_read role 2412 Console Synch Console alerts generated by the console no longer cause unexpected behavior with the console alert list dialogue 2455 General SQL Server Agent jobs are no longer synchronized unless one or more jobs have changed (job history is still synchronized as usual) 2415 General The buttons on the set QuickTrace duration dialogue are cut off for some users 2380 General An explicit "queue for up to" time setting should now always unlock properly 2147 Navigator Performance Advisor objects in the Event Manager calendar will no longer throw a warning if selected while the SQL Server is in the node 2499 Navigator Support for SQL Server 2000 tools integration should now be more reliable 2419 Navigator Settings will now update when selecting the Devices root node after selecting a job on the All Devices view 2383 Objects-Properties Resolved some minor issues with placeholder job creation 2461 PA-Blocking Resolved some minor issues with the "Kill blocking SQL process" feature 2464 PA-Blocking Removed invalid columns from the Block Chain column selector dialogue 2449 PA-Dashboard The Performance Advisor toolbar no longer wraps to the 2nd line at 1024x768 under Vista 2494 PA-Disk This view will now display the "no data for range" message if there is no data for the specified range 2156 PA-Disk Fixed some calculation issues with the "% Write Bytes" values on the Disk Activity tab 2408 PA-Disk Invalid Logical Disk to Partition mappings will now be removed during synchronization 2420 PA-Disk Disk space tooltips will now always show details for the correct file 2492 PA-Disk SQL data file size will no longer be incorrectly reported as being lower than it actually is 2181 PA-General We've fixed some minor issues with some of the Performance Advisor data grid exports 2463 PA-General If a database is in a state that does not allow connections, we no longer attempt to connect to it 2520 PA-QuickTrace The Quick Trace function will now work with the right click menu on the Disk Space Tab 2213 PA-QuickTrace Clicking "Refresh" no longer causes separate QuickTraces to be logged 2475 PA-QuickTrace Corrected problems with % of total calculations for QuickTrace detail rows 2459 PA-QuickTrace Users are no longer able to use Performance Advisor after all connections have been unwatched with Performance Advisor 2465 PA-Top SQL We now define which Trace Server type is erroring in the Top Queries error text 2524 PA-Top SQL removed "Missed Run Threshold" from the settings for "Top Commands Source" as it is invalid in that context 2462 Performance Opt. Various internal query optimizations have been made to minimize processing on remote connections 2471 Queuing Queue Monitor job is now disabled while there are no actively queued jobs 2506 Queuing Queue for Up To and other queuing settings are no longer available if Queue Type is never 2442 Remote Procs We've added better exception handling for object creation/upgrade failures in the SQL Sentry server service 2229 Reports Performance Advisor settings are no longer shown on the Active Settings report 2478 Server-Service Load balancing will now properly handle Unwatched Connections 2426 Setup Increasing the Model database primary file size no longer causes a database creation error during setup 2485 Watching The version check error messages have been made more more precise and deterministic ========================================================================================== Change List SQL Sentry Build 5.0.56 Date: 13/AUG/2009 ========================================================================================== FIXES: ID Component Name 2504 PA-Blocking Blocks may not correctly show as running if not associated with a job ========================================================================================== Change List SQL Sentry Build 5.0.55 Date: 29/JUL/2009 ========================================================================================== FEATURES: ID Component Name 2467 General Exception: Collection was modified; enumeration operation may not execute 2483 General Exception: A network-related or instance-specific error occurred while establishing a connection to SQL Server 2484 General Exception: Object reference not set to an instance of an object 2488 General Quick Trace action can cause service to stop collecting in certain configurations ========================================================================================== Change List SQL Sentry Build 5.0.49 Date: 16/JUL/2009 ========================================================================================== FEATURES: ID Component Name 648 PA-QuickTrace Added "Show Statement events if available" filter to the QuickTrace view filters ========================================================================================== FIXES: ID Component Name 2480 General Exception: Could not find stored procedure 'spGetBlockInfo_20' 2479 Setup Upgrading using SQL authentication causes install failure ========================================================================================== Change List SQL Sentry Build 5.0.46 Date: 13/JUL/2009 ========================================================================================== FIXES: ID Component Name 2472 Calendar/List view When using Jump To->History->x Days it doesn't load the first time 2476 Chaining Unable to view Event Chain history for certain chains 2468 General Fresh install of console prompts on console startup to select database 2469 General Speed up purge process with new indexes 2470 General Reduce number of remote object check calls 2270 PA-Blocking Blocks aren't always closed out properly if service is terminated 2452 PA-Dashboard SQL Server 2008 instances show consistent Tracing waits on dashboard 2451 PA-General Performance counters that point to an offline server can cause delays in Performance Advisor collection 2473 Remote Procs Remote objects aren't recreated when upgrading SQL Server major version and from 2000 SP2 to higher ========================================================================================== Change List SQL Sentry Build 5.0.40 Date: 24/JUN/2009 ========================================================================================== FIXES: ID Component Name 2458 Setup-Upgrade While upgrading a 4.x repository the SQL Sentry setup could error out when setting private key encryption password ========================================================================================== Change List SQL Sentry Build 5.0.39 (Release Candidate) Date: 24/JUN/2009 ========================================================================================== FIXES: ID Component Name 2454 PA-General SSAS data collection was not working on some international systems ========================================================================================== Change List SQL Sentry Build 5.0.33 (Release Candidate) Date: 10/JUN/2009 ========================================================================================== FEATURES: ID Component Name 640 PA-Dashboard Added scale max rounding for certain PA charts to help avoid uneven scale breaks ========================================================================================== FIXES: ID Component Name 2445 Menus Changing between SSIS logging options can cause undesired manipulation of the original DTEXEC command line 2446 PA-Dashboard Exception: "The value is too large or too small for value type Decimal" when opening the dashboard 2447 PA-Dashboard Adding a connection that is already watched to a device could prompt to reopen the dashboard 2444 Server-Service The server service could not synchronize history for Task Scheduler 2.0 ========================================================================================== Change List SQL Sentry Build 5.0.28 (Beta) Date: 03/JUN/2009 ========================================================================================== FEATURES: ID Component Name 639 PA-Dashboard The dashboard will now maintain current history range and state information when changing the active SQL/SSAS instance ========================================================================================== FIXES: ID Component Name 2441 PA-Dashboard Exception could occur when opening PA before all PA subsystems had been fully initialized ========================================================================================== Change List SQL Sentry Build 5.0.26 (Beta) Date: 01/JUN/2009 ========================================================================================== FEATURES: ID Component Name 628 Alerting-Formatting Added a link to the KB article for agent log size warning messages ========================================================================================== FIXES: ID Component Name 0000 General Corrected 4 defects that were submitted through the automated exception reporting system 2432 Alerting Action throttling will no longer report incorrect throttle time remaining 2217 Alerting-Formatting Fixed some formatting issues with Event History Monitor errors 2423 General Opening two consoles to the same repository on the same workstation is no longer allowed 2431 General Scrolling grids in 64-bit windows will no longer cause console errors 2439 Objects-Properties Tool support for SQL Server 2000 objects in SSMS 2005 and 2008 has been restored 2437 PA-Dashboard The PA dashboard will no longer go into auto-refresh mode after using the "Jump To" menu option to go to another PA tab 2438 PA-General Using the Jump to->Performance Advisor->[*] menu would not always jump to the correct PA tab 2440 PA-Top SQL The data retrieval queries have been optimized to return faster when there are millions of trace rows 2433 PA-Windows Processes The Process Activity Viewer will no longer crash the SQL Sentry Console if the user does not have WMI rights 2378 Queuing Some unnecessary dependencies in the queue monitor procedure have been removed ========================================================================================== Change List SQL Sentry Build 5.0.19 (Beta) Date: 15/MAY/2009 ========================================================================================== FEATURES: ID Component Name 000 General NEW PRODUCT: SQL Sentry Performance Advisor for Analysis Services 594 Alerting Global email throttling by condition and recipient 625 Calendar view Allow the SQLAgentReaderRole built in role to see running jobs on the calendar 629 Event Views Converted the Event Sources dropdown in event view filters to a checked listbox 408 Filter Added an option to show only watched objects to the event view filters 340 General Allow connecting to a different repository without quitting application 635 General Server service configuration utility enhancements 596 Icons New navigator and toolbar icons 597 Navigator Added context menu to auto-create device nodes from Unassigned connections 584 Navigator Merged the Jump To... and Show... menu commands 574 Objects-Conditions Expanded Output Content Match for Blocking and Top SQL to include matching for SQL text, database, app name, etc. 600 PA-Blocking Indicate active blocks by Showing the blocking chain head node in orange 638 PA-Dashboard Updated warning and critical ranges for CPU context switches and queue length digital gauges 626 PA-Deadlocks Sequence numbers added to deadlock graphs to show locking chronology 612 PA-Disk Historical disk space support 615 PA-General Kill SPID functionality for QuickTrace and Blocking SQL 618 PA-QuickTrace Auto-expand SQL stack rows when selecting a deadlock graph spid node 611 PA-QuickTrace Export functionality for QuickTrace data 617 PA-QuickTrace QuickTrace options are now persisted between console sessions 619 PA-Top SQL Ability to filter Top SQL trace rows by cpu/reads/writes 621 Watching Separate remote object creation for PA vs EM, so PA only installations don't require remote objects for EM ========================================================================================== FIXES: ID Component Name 0000 General In addition to this list, we've corrected over 50 defects that were submitted through our automated exception reporting system! 2350 Alerting Runtime Max completion notifications should now always generated for time-based rulesets 2291 Alerting Disabled contacts are now indicated as such in the send email action configuration options 2324 Alerting-Formatting Fixed formatting for audit alerts 2116 Alerting-Formatting Added the "Condition" to all notifications and log messages 2264 Alerting-Formatting Fixed a wait type formatting issue in SQL Server 2000 blocking messages 2373 Calendar view Fixed an issue where the "Current time" tooltip was not displayed when hovering over the duration bar 1619 Calendar view Fixed some calendar navigation issues that could occur on the day of the DST "Spring forward" change 2307 Calendar view Fixed some issues with Top SQL and calendar recurring event pane 2192 Calendar view Fixed an issue with the scrollbar in the recurring event pane 2227 Chaining The chain diagram will no longer say "Edit ..." even in non-edit mode 2199 Chaining The chain editor no longer allows duplicate names 2386 Chaining Event chain runtime duration doesn't calculate correctly across different timezones 2234 Contacts-Users Newly created users seem to be disabled by default 2073 Event Views Cannot set the SQL Servers node as the default view 2289 Event Views The Event Sources list for views should be sorted the same as settings 1672 Event Views Saving the Global view as a Custom Event View may persist the original view's name and description properties 1374 Filter The Sources tab for the All SQL Servers view shows the same information as the All Devices view 2140 General Don't show the sync prompt if we have source errors related to the source being offline 2225 General Exceptions caused by Reporting Services database being dropped 2184 General Multi-step jobs do not identify start step 2346 General Only a sysadmin or the job owner can start SQL Server Agent jobs (Agent Operators can now as well) 2406 General SQL Server Agent Log event source is not created for new connections 2395 General SSIS step details don't appear for certain jobs 2075 General Fixed an issue with Task Scheduler 2.0 security 2161 Graphs-Performance Performance graph Prev/Next major interval toolbar buttons only move a small interval 2417 Graphs-Performance Toolbar doesn't update if you pause on performance chart and then open another performance chart for the same object 2170 Graphs-Runtime Runtime graphs will not show for a single day 2237 Graphs-Runtime X-axis of the Runtime Graphs shows the start date in US format 2405 Licensing The console doesn't reload license while it's running and you can unwatch newly watched servers if license is upgraded 2130 List view Made the Days toolbar control wide enough to show 3 digits 2348 Logs The "Jump To This Instance" context item is not available from the All Actions log 2118 Logs Fixed a formatting issue for action names in the actions logs 2331 Menus Calendar instances don't have watch context menus 2407 Navigator Attempting to watch an offline server can return "You must have administrative privileges to watch this object." 2097 Navigator Formatting issues with the change folders menu items 2342 Navigator The new SQL Server registration form will show when no provider is available 2287 Navigator SQL Server registration not visible in Navigator after deleting then re-adding it 2241 Objects-Actions Execute job action available for unwatched servers 1340 Objects-Conditions Corrected a problem that could cause invalid "Run Missed" messages to be generated 2329 Objects-Properties The name entered for a new schedule when creating a placeholder job is not used when creating the schedule object 2214 PA-Blocking Running blocks do not show up on calendar if a filter is applied 2430 PA-Dashboard The "No Data for Range" labels don't always disappear when new data comes in 2396 PA-Dashboard CPU Activity in PA Dashboard registers more SQL Server activity than total activity 2429 PA-Dashboard Increased max digits for context switches and page life expectancy digital gauges to prevent overflow in extreme cases 2372 PA-Disk All disk metrics aren't displayed for "Other files" element tooltip 2314 PA-Disk Disk activity latency values always show disk latency versus max calculated latency 1957 PA-Disk Disk Activity shows unusual values in Sum mode 2313 PA-Disk Disk activity stops auto-refreshing after switching to a different tab 2334 PA-Disk Disk Controller Manufacturer needs to allow nulls 2282 PA-Disk Selecting a SQL file selects all files with the same db name, regardless of instance 2252 PA-Disk Selecting the Other files element doesn't auto-select the associated Disk row in the grid 2238 PA-Disk Slow response and no tooltip when selecting a file element on Disk Space tab 2318 PA-Disk When hiding the Navigator pane, disk layout on Disk Space tab does not resize properly 2306 PA-General Console alerts tooltip formatting changes 2387 PA-General Performance Advisor status error change for inactive SQL Sentry Server service 2366 PA-General WMI and SQL Server schemas do not refresh on their own. 2131 PA-QuickTrace The "Maintain row position when changing sort" option is non-functional for child rows 2253 PA-QuickTrace Not allowed to run a QuickTrace > 1 minute 2058 PA-QuickTrace QuickTrace fails when run against an upgraded 2005 server 2341 PA-QuickTrace QuickTrace dialog formatting changes 2284 PA-QuickTrace Show QuickTrace processes feature isn't working 2403 PA-QuickTrace When QuickTrace process rows are saved, CPU is saved into the physical writes column 2221 PA-Top SQL The "Server" child column is always added after making parent column changes 2321 PA-Top SQL Formatting issues when changing Top SQL grouping 2155 PA-Top SQL Hidden Top SQL is always visible when in detail mode 2296 PA-Top SQL Issues with Jump To->Runtime Graphs for Top SQL totals rows 2233 PA-Windows Processes Some Windows process metrics do not return values 2195 Performance Monitoring Jobs with Performance counters linked from offline servers cause performance collection to fail 2150 Performance Monitoring Formatting changes to add Performance Counter warning message box shown when view doesn't contain any monitorable objects 1516 Performance Monitoring Unwatching a connection with monitored objects doesn't stop performance counter collection 2251 Performance Opt. Optimizations made to the event schedule resolution process 2207 Product Selector No prompt to watch the selected instance when trying to open an unwatched instance on a with multiple instances 2305 Reports Issues with SSRS Folders when deploying reports 2275 Reports Report deployment preferences form 2230 Reports Report parameter form formatting issues 2292 Server-Service Some thread wait times are not updated after the service is started 2413 Setup Error trying to open the Remoting dll for removal during upgrade 2276 Setup Support provided for the SSMS AddIn Automated Install on Windows Vista 2384 Setup Username and password are not persisted for SMTP settings when using the quick start setup wizard 2409 Setup When a connection is added in the quick start wizard with watch options, it doesn't honor the license count 2173 User Preferences Cleared failures are now hidden from the Current Failures report 2299 Watching Errors thrown during the "install remote scripts" phase when watching with the quick start wizard can cause the console to crash 2288 Watching Errors in the console alerts window persist during the same session even after unwatching the associated connection ========================================================================================== Change List SQL Sentry Build 4.2.0.29 Date: 22/JAN/2009 ========================================================================================== FIXES: ID Component Name 2350 Alerting Runtime Max completion notifications will now be correctly generated for time-based rulesets 1340 Objects-Conditions Invalid Run Missed messages should no longer be generated ========================================================================================== Change List SQL Sentry Build 4.2.0.28 Date: 14/JAN/2009 ========================================================================================== FIXES: ID Component Name 2336 Alerting-Rulesets Duplicate messages can no longer be sent with count-based rulesets for stateful conditions 2338 General An error experienced by some concerning a missing file or assembly for 'Microsoft.SqlServer.SMO' or 'Microsoft.SqlServer.RegisteredServers' has been fixed 2105 Server-Connections Adding a connection can no longer continue indefinitely in cases where the WMI service is running, but has managed to become hung 2343 Setup Single user mode is no longer necessary when adding a service to an existing, same version installation ========================================================================================== Change List SQL Sentry Build 4.2.0.26 Date: 17/DEC/2008 ========================================================================================== FEATURES: ID Component Name 116 Calendar view Make the popup up/down arrows on the time bar only go a small increment 599 Exception Reporter Add Performance Advisor table counts to the exception reporter details 514 General Provide SQL Server 2008 support (updates for SSMS integration) 418 General Add the ability to watch offline servers that had been watched previously in order to access history 479 General Updates to the SQL Server Agent log size constraints 480 Licensing Add a standby license type which allows for up to two server instance names 592 PA-Disk Enable support for USB and IEEE1394 disk controllers 566 PA-General Allow opening the Performance Advisor console even when some Performance Advisor features may be unavailable 591 PA-General Add a new sample collection interval for database counters 549 Server-Connections Provide better support for cross domain connections 562 Setup Provide for in-place installation of the SSMS Automator from the Console ========================================================================================== FIXES: ID Component Name 2028 Alerting SQL Server 2005 WMI alerts can cause unhandled exceptions 2216 Alerting Persistant conditions triggering other conditions (ie. kill job triggers job complete) can cause notifications the seem to violate the "Notify Once" ruleset 2265 Alerting-Rulesets The "don't notify after" duration isn't honored for Time-based rulesets 2302 Alerting-Rulesets Multiple time-based rulesets for the same condition can cause false notifications 2218 Auditing-Actions Audit messages are not sent if synchronized from Event View 2190 Auditing-Actions Audit actions are not refreshed after running the quick-start wizard 1495 Auditing-Conditions The "Object Created" message is not generated for new placeholder jobs 2007 Calendar view Exception: No printers are installed 2310 Calendar view The dates do not display on the calendar label until you move your mouse over them 2311 Calendar view Exception: Value cannot be null. Parameter name: brush 2124 Chaining Event Chain Min Runtime notifications are generated even if the min runtime was met 1845 General Exception: A possible database consistency problem has been detected 2179 General The Event Manager history purge process can be run by more than one Server service 2152 General Select the new ruleset after creating it from the actions pane 2215 General Jobs that are manually started/stopped quickly are not always monitored for every run 2235 General A notification can be sent before the rulesets have finished loading 2202 General Losing the network connection causes various problems data collection problems 2208 General The service configuration utility binary needs to be digitally signed 2210 General Various formatting issues with the ruleset editor 2257 General Improve performance when synchronizing history detail 2239 General Fix UI scaling issues on the product selector form 2240 General Choosing Open on the devices node when the all devices calendar is already open loads a second all devices calendar 2224 Graphs-Runtime The "Selected Item" dropdown should only be shown for relevant runtime graphs 2174 Graphs-Runtime Make the [Show->Runtime Graphs] context menu command work like the "Jump To" commands and use a date range 2285 Navigator Event source root nodes can be deleted using the delete key 2204 Navigator The 'Open' command off the devices node does nothing 2157 Navigator The option to automatically synchronize the navigator with the selected tab doesnt work for every tab 2191 Navigator Changes to the product selector form to improve usability and reduce confusion 2146 Navigator Connections registered under Devices group can still show in the UNASSIGNED group 1943 Navigator Various issues with custom folders for custom event views 2141 PA-Blocking Blocks that don't meet the duration threshold can be returned if there are longer blocks running at the same time on the same connection 2203 PA-Blocking Exception: Value cannot be null. Parameter name: text 2243 PA-Blocking The block duration setting is not correctly inherited in all cases 2223 PA-Disk When switching the grid style from disk to database the grid size changes unpredictably 2024 PA-Disk Exception: Rectangle '{X=0,Y=26,Width=0,Height=35}'... 2198 PA-Disk The scroll bars on the disk view grid are calculated inconsistently 2220 PA-General Provide a more user friendly message for WMI "access denied" errors 2283 PA-General Scanning for configuration changes seems to never complete 2297 PA-QuickTrace The QuickTrace list grid should make more effective use of screen real estate 2219 PA-QuickTrace Fix various QuickTrace calculation inconsistencies 2187 PA-QuickTrace Minor usability tweaks to the QuickTrace interface 2188 PA-QuickTrace If the connection has not been in online status during the console session then loading QuickTrace data could cause the application to crash 2175 PA-Top SQL The settings groups for Top SQL Source are sorted inconsistently 2151 PA-Top SQL Trim any whitespace characters from normalized SQL 2087 PA-Top SQL Exception: Parameterized Query '(@NormalizedTextMD5 binary(16)...' 2231 PA-Top SQL Improve load times for the Performance Advisor console 2211 PA-Top SQL The Top SQL trace can be interrupted if an error occurs during a restart 2295 PA-Top SQL The Top SQL runtime graphs display incorrect information in tooltips 2319 PA-Top SQL usability tweaks to the Top SQL grid display 1481 Server-Connections Ensure that Task Scheduler failsafe conditions are operating reliably 1831 Server-Service Exception: Could not allocate space for object 'EventSourceHistory' 2159 Server-Service Inability to write to the initialization log can crash the server service 2260 Server-Service The server Service can timeout while during startup 2236 Server-Settings The Performance Advisor SQL Servers settings do not inherit properly for some connections 2254 Setup The installation can suggest a database upgrade when it should suggest new database creation 2256 Setup Simplify the default SQL Sentry installation directory 2259 Setup Communicate startup failures for the server service during setup 2268 Setup Upgrading the repository database using SQL Authentication tries to use integrated authentication 2271 Setup Upgrading and choosing to install only the console application doesn't import the settings for the repository location 2194 Setup Remove the default "from address" from QuickStart wizard SMTP properties step 2171 Setup Clicking refresh on the "Watch Connections" QuickStart wizard step resets all the checked items 2129 Setup Setup dialogs can drop behind main setup window 2134 Setup Do not select the option to send email for "all Audit conditions" by default during QuickStart wizard 2303 Setup-Upgrade Consolidate application upgrade removal dialog prompts 2153 Toolbar Performance Advisor toolbars do not always wrap correctly when running at certain lower resolutions ========================================================================================== Change List SQL Sentry Build 4.1.0.17 Date: 03/Oct/2008 ========================================================================================== FIXES: ID Component Name 2196 General Exception: idParameter name: id cannot be default ========================================================================================== Change List SQL Sentry Build 4.1.0.18 Date: 10/Oct/2008 ========================================================================================== FIXES: ID Component Name 2205 Server-Service Invalid stored procedure call can be cached from previous version ========================================================================================== Change List SQL Sentry Build 4.1.0.17 Date: 03/Oct/2008 ========================================================================================== FIXES: ID Component Name 2196 General Exception: idParameter name: id cannot be default ========================================================================================== Change List SQL Sentry Build 4.1.0.15 Date: 30/Sep/2008 ========================================================================================== FEATURES: ID Component Name 568 Calendar view Calendar Time Ruler 24-hour clock support 529 General Usability Enhancements for Console Alerts window 535 General Export functionality for Performance Advisor tabs 536 General Tab auto-rotation functionality 558 Graphs-Runtime Add selector for Top SQL statement in runtime graphs 542 Navigator Product Selector when opening a device or connection node via left-click. 569 Notifications Allow specifying email importance and from address in email actions 577 Notifications Mask "agent log exceeded 1 megabyte" emails. 553 Objects-Settings Show actions and settings for all singleton event sources when selected in the Navigator. 551 PA-Blocking Block Version Grouping 580 PA-Dashboard Persistence for chart cursor and range selection while navigating. 572 PA-Dashboard Labels on dashboard to indicate selection range and sample time/interval 573 PA-Dashboard Range/Sample point selection context menu items 552 PA-General Show conditions and actions for each PA tab. 541 PA-QuickTrace Prompt user when no rows are displayed because "Hide rows with empty values in sort column" option is enabled. 570 PA-QuickTrace Add QuickTrace option to show rows with no activity 550 PA-Windows Processes Add "Show Windows Processes" context item to Device nodes and "Run QuickTrace" context item to SQL connection nodes. 544 Setup Streamline password entry for private key during install 547 Setup Add ability for user to reset password for private key ========================================================================================== FIXES: 1913 Calendar view Calendar event instances don't extend to bottom in 1 minute view. 2074 Chaining Sort Event Chains alphabetically in Navigator 2060 Chaining Jump To > This Instance context menu item for chain nodes jumps to current time instead of node execution time 2085 Chaining Exception: Object reference not set to an instance of an object. 2109 Database Exception: Error converting data type nvarchar to datetime. 2144 Event Views PA event sources show up in views even if the connection isnt watched with PA 2167 Event Views When selecting “All SQL Servers” for a new view, “Select Event Sources” button does not enable. 2012 Event Views Sample Views do not save changes to the settings between console restarts 2182 General Exception: SQL Server blocked access to procedure 'dbo.sp_get_composite_job_info' 2186 General Auto-clear failures can cause exceptions 1923 General Exception: Rectangle '{X=0,Y=26,Width=0,Height=35}' cannot have a width or height equal to 0. 1789 General Exception: Parameter is not valid. 2059 General Exception: Cannot access a disposed object.Object name: 'MainForm' 2103 General Ssms integration doesnt work if SQL Servers have not been registered in Ssms 2089 General DTS rows do not link detail rows if the DTS source is reseeded 2067 Graphs-Runtime Using the Print button on toolbar for Runtime Graphs produces blank page 2062 Licensing Console forced to close whenever clicking Close on Manage Licenses screen, even if nothing changed. 2040 List view Selecting Show History->1 Day only goes back to 12am of the current day 2034 List view History list is not refreshed when selecting Show History context item and the history list is already opened. 2068 Logs Open->Event Manager Calendar is non-functional in action log entries for Task Scheduler connections. 2069 Logs Exception: Object reference not set to an instance of an object. 2070 Logs Actions log sorting issues 2065 Logs Unconfigurable conditions show up in logs 2119 Logs Cluster failover condition isnt logged to Actions Log 2160 MDI Console alerts window issues. 2158 Navigator Watch connection with EM when adding connection only works every other time 2092 Navigator Exception: Object reference not set to an instance of an object. 2106 Navigator Failures not escalated in navigator until connection node is expanded 2064 Navigator Event Chain node in Navigator not displaying error status 2079 Navigator Showing PA sources in Navigator when a connection isn't watched with EM. 2082 Navigator Add as watched checkbox on new connection screen only watches EM. 2076 Navigator Event View node names beneath eventsourceobject nodes are too long 2057 Notifications Top SQL notification formatting 2137 Notifications Stop audit emails from the quickstart wizard 2114 Objects-Actions Exception: The parent form must have its handle created prior to calling this method 2071 Objects-Conditions SQL Agent log entries are logged multiple times. 2078 Objects-Settings Remove General property group for connections when no applicable properties 2096 PA-Blocking SQL textbox is not cleared when there is no selected row in the blocking list grid. 2018 PA-Dashboard PA not resuming after SQL Cluster failover 2053 PA-Deadlocks Exception: Index was out of range. Must be non-negative and less than the size of the collection. 2093 PA-Deadlocks Exception: Object reference not set to an instance of an obje 2091 PA-Disk Single brace in Win32_SCSIController data causes WMI error 2024 PA-Disk Exception: Rectangle '{X=0,Y=26,Width=0,Height=35}' cannot have a width or height equal to 0. 2016 PA-Disk Disk Space issues 2035 PA-General Jump To Calendar context item on PA always opens up a new tab. 2049 PA-General Windows Processes scaling issue on machines with multi-core processors 2072 PA-General PA can be opened for devices with multiple unwatched SQL connections if one has been previously watched. 2172 PA-General Purge and Rollup processes can be run by multiple Server services at the same time. 2177 PA-QuickTrace SP:StmtCompleted events dont collect reads/writes/cpu/duration 2037 PA-QuickTrace QT Tab, Target dropdown needs filtering 2056 PA-Top SQL Hidden SQL should not be included in the Top X rows 2087 PA-Top SQL Exception: Parameterized Query '(@NormalizedTextMD5 binary(16)...' 2051 PA-Windows Processes Windows process viewer taking too long upon initial load. 2163 Performance Monitoring Rulesets dont work properly if you have more than one performance counter assigned to an object 2104 Remote Procs It is possible to create remote objects under the context of a non-sysadmin in certan situations 2036 Server-Settings Exception: The parent form must have its handle created prior to calling this method 1431 Server-Settings Do not send actions for any of the initial history sync rows. Only send after first sync. 1690 Setup Setup Wizard Hangs if trying to watch SQL Server where Agent is offline 2083 Setup Improvements to setup wizard "Watch Connections" screen. 2107 Setup Pasting a password causes login failure on Create/Upgrade database screen. 2102 Setup Quick Start wizard uses same status for watching with PA or EM 2178 Setup 4.1 service install can fail if installing under different user account than logged in user 2121 Setup Get error about not having being able to find server with SysAdmin rights during quick start wizard. 2122 Setup Clicking back on quick start wizard and deselecting connection to watch doesnt unwatch it during initial setup 2128 Setup Auto-navigate to the connections list screen after Connection Discovery is complete. 2110 sp_sentry_mail sp_sentry_dbmail doesn't work in certain culture combinations 1752 User Preferences 'Time ruler font color' and 'event instance font color' user color-preferences do not function 2115 Alerting-Formatting Blocking and Deadlock message formatting issues. 2077 Alerting-Formatting Maintenance Plan step failures treated as object failures 2015 Alerting-Rulesets Sort rulesets alpha asc in manage rulesets list and all drop-downs 2112 Alerting-Rulesets Response Ruleset cannot be deleted ========================================================================================== Change List SQL Sentry Build 4.0.0.48 Date: 11/Aug/2008 ========================================================================================== FIXES: 2080 General Tasks seen as deleted when problems are encountered during synchronization 2098 PA-General Performance counter data may not be collected 2100 Setup Setup doesnt properly check if SQL Server 2008 Management Studio is closed 2099 sp_sentry_mail sp_sentry_mail doesn't work in certain culture combinations ========================================================================================== Change List SQL Sentry Build 4.0.0.44 Date: 17/July/2008 ========================================================================================== FEATURES: ID Component Name 533 General Allow setting selection from Performance Advisor console. 534 General New toolbar for Performance Advisor. 536 General Tab auto-rotation functionality. 539 PA-Dashboard Added 'No Data for Range' message to all charts for both sample and history modes. 540 PA-Dashboard Progress and status bar information is displayed when loading dashboard history and sample data. 487 Setup Installation process changes for v4.0. 537 Setup Separate watch with PA and watch with EM tasks in Quick Start Wizard. ========================================================================================== FIXES: 1679 General Exception: Cannot insert duplicate key row in object 'IEventSourceConnectionSettings' with unique index 'IX_IEventSourceConnectionSettings_ObjectID_SettingTypeID'. 1919 General Exception: String or binary data would be truncated. The statement has been terminated. 2032 General Synchronization errors can occur if DTS event sources are reseeded. 2055 General Exception: Object reference not set to an instance of an object. 1664 Navigator Exception: The transaction was rollbacked or commited please provide an open transaction. 2054 Navigator Exception: Key cannot be null.Parameter name: key 2022 PA-Dashboard Exception: Cannot resolve collation conflict for equal to operation. 2041 PA-Dashboard Waits chart shows abnormally low CPU values in sample mode. 2042 PA-Dashboard SQL CPU % of Total waits gauge showing high values when total waits are very low. 2043 PA-Dashboard Missing data on charts when navigating to a different range when the previous range was still loading. 2044 PA-Dashboard Sample data not being loaded correctly when viewing aggregated history data. 2045 PA-General Progress bar doesnt update when switching tabs. 2047 PA-Dashboard CPU instances don't sort properly when >=10 processors. 2052 PA-Top SQL Exception: Object reference not set to an instance of an object. ========================================================================================== Change List SQL Sentry Build 4.0.0.39 Date: 01/July/2008 ========================================================================================== FIXES: 2023 General Exception: Cannot insert duplicate key row in object 'dbo.CustomEventView' with unique index IX_CustomEventView-StorageCode-Owner-IsDefaultForCustomEventViewID'. 2029 General Exception: The transaction was rollbacked or commited, please provide an open transaction. 2030 General Duplicate SQL Agent log messages on SQL Server 2005. 1848 Navigator Exception: The transaction was rollbacked or commited, please provide an open transaction. 2013 Alerting-Rulesets Issues with Runtime Threshold Max Condition for Windows Task Scheduler. 2009 Objects-Actions Exception: The given key was not present in the dictionary. 2026 PA-Deadlocks Change Deadlocks event time to use local time (not UTC). 2019 PA-Disk Exception: Incorrect syntax near '1'. 1985 PA-QuickTrace QuickTrace should not show ‘1753-01-01 00:00:00.000’ for open end times. 2020 PA-QuickTrace Exception: The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value. 2021 PA-QuickTrace Exception: Object reference not set to an instance of an object. 2027 PA-QuickTrace You must have a parent form assigned prior to calling this method. 2025 Server-Service Console error after installing 4.0.0.38. ========================================================================================== Change List SQL Sentry Build 4.0.0.38 Date: 23/June/2008 ========================================================================================== FIXES: 1942 General SQL Server 2005 Maintenance Plans can possibly be skipped by the history synchronizer. ========================================================================================== Change List SQL Sentry Build 4.0.0.37 Date: 19/June/2008 ========================================================================================== FIXES: 2007 Calendar View Exception: No printers are installed. 2008 Event Views Exception: Object reference not set to an instance of an object. ========================================================================================== Change List SQL Sentry Build 4.0.0.36 Date: 18/June/2008 ========================================================================================== FIXES: 1818 Calendar view Exception: Collection was modified; enumeration operation may not execute. 1875 Calendar view Exception: intervalType cannot be IntervalType.Custom 2005 Calendar view Top SQL instances do not show as conflicting with themselves 1961 Calendar/List view Show history context menu for objects does not show the correct range 1770 Chaining Exception: A transport-level error has occurred when sending the request to the server. (provider: Named Pipes Provider…) 2006 Chaining Exception: Insert Error: Column name or number of supplied va 1832 Event Views Exception: A transport-level error has occurred when sending the request to the server. 1883 Event Views Message: Cannot insert duplicate key row in object 'dbo.EventSourceObject' with unique index 'IX_EventSourceObject_EventSourceID_ObjectName'. 1805 Event Views Exception: Object reference not set to an instance of an object 1865 Event Views Exception: Specified cast is not valid. 1850 Event Views Exception: Thread failed to start. 1845 General Exception: A possible database consistency problem has been detected on database 1776 General Message: A transport-level error has occurred when receiving results from the server. (provider: TCP Provider…) 1796 General Exception: A transport-level error has occurred when sending the request to the server. (provider: Named Pipes Provider…) 1893 General Exception: AverageValue 1584 General Exception: Cannot generate SSPI context. 2001 General Exception: Cannot insert duplicate key row in object 'dbo.PerPerformanceAnalysisSubsystemRefreshRequest' 1846 General Exception: Cannot process request because the process has exited 1868 General Exception: Collection was modified; enumeration operation may not execute. 1873 General Exception: Insufficient memory to continue the execution of the program. 1853 General Exception: Object reference not set to an instance of an object. 1787 General Exception: Specified cast is not valid. 1844 General Exception: The log for database 'tempdb' is not available. 1869 General Exception: Value was either too large or too small for an Int 1888 General MaintenanceWindow Lookup problem when repository down 1941 General No confirmation or record of deleting a device, or a connection under devices 1971 List view Show History context item selects incorrect range. 1874 Logs Exception: Unable to synchronize log file because it exceeds one megabyte 1825 Navigator Message: Cannot insert duplicate key row in object 'dbo.EventSourceObject' with unique index 'IX_EventSourceObject_EventSourceID_ObjectName'. 1807 Navigator Exception: Error retrieving remote time on server 1710 Navigator Exception: Invalid object name 'SQLSentryObjectVersion_20'. 1830 Navigator Exception: Item has already been added. Key in dictionary: '00000000-0000-0000-0000-000000000000' 1693 Navigator Exception: The handle is invalid. 1581 Navigator Exception: The parent form must have its handle created prior to calling this method. 1866 Notifications Exception: Object reference not set to an instance of an object. 1701 Objects-Actions Exception: INSERT statement conflicted with COLUMN FOREIGN KEY constraint… 1998 PA-Disk You cant select a file by clicking on the top half in the Disk Space tab 2003 PA-QuickTrace Exception: SqlDateTime overflow. Must be between 1/1/1753 12: 1997 PA-Top SQL Message: Parameterized Query '(@NormalizedTextMD5...) expects parameter @ApplicationName, which was not supplied 1969 PA-Top SQL SQL window doesn't always refresh when changing grid rows in grouped mode. 1870 Performance Monitoring Exception: Parameter count does not match Parameter Value count. 2002 Performance Monitoring Exception: There is already an object named 'PK_tempTimestamps' in the database. 1736 Server-Service Exception: A time out occurred while waiting for memory resources to execute the query. Rerun the query. 1831 Server-Service Exception: Could not allocate space for object 'EventSourceHistory' 1817 Server-Service Exception: Server user is not a valid user in database 'ReportServer'. 1668 Server-Service Exception: Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool… 1921 Server-Settings Exception: Object reference not set to an instance of an object. ========================================================================================== Change List SQL Sentry Build 4.0.0.30 Date: 11/June/2008 ========================================================================================== FIXES: 1996 General Reset Layout doesnt always reset the layout 1995 Navigator Adding a registration or group under a SQL group registration node doesnt show newly added registration or group 1986 PA-Blocking Block durations are incorrect 1987 PA-QuickTrace QuickTrace says Collecting... when loading data 1993 PA-Top SQL Hidden columns do not contain data in grouped mode. 1992 PA-Top SQL Removing a grouping column and adding it back doesnt reload grid. 1991 PA-Top SQL SQL Server column not visible on multi-instance computers in raw mode 1994 Server-Service Performance Advisor does not initialize on Win2k systems if logical disk category is not enabled ========================================================================================== Change List SQL Sentry Build 4.0.0.29 Date: 10/June/2008 ========================================================================================== FIXES: 1978 Calendar view Calendar tooltips may show blank lines 1981 Calendar view Top SQL source should honor hidden Top SQL on calendar view 1984 Event Views Event views that use Connection Types may time out 1977 Event Views Resetting a custom event view can delete random views 1976 Event Views Resetting a custom event view filter resets all active views 1980 General Form load errors do not show up in status bar 1979 Navigator Refreshing custom event view folder nodes doesnt show views that were removed by others 1982 Notifications Time based rulesets with zero value for Notify For Up To use zero, not indefinite 1974 PA-QuickTrace Progress meter status enhancements for QuickTrace 1975 PA-QuickTrace Quick Trace save performance enhancements 1983 PA-Top SQL Top SQL doesnt show a sort indicator by default ========================================================================================== Change List SQL Sentry Build 4.0.0.27 Date: 06/June/2008 ========================================================================================== FEATURES: 000 General NEW PRODUCT: SQL Sentry Performance Advisor for SQL Server 433 Auditing-Conditions Auditing for contact changes. 499 Auditing-Conditions Auditing for custom event view creation and deletion. 467 Calendar/List view Add "Jump To -> This Instance" context item to all objects in multi-server views. 413 Chaining Add a Save As... option for copies of Event Chains. 424 Chaining Add nodes to chains by dragging from the Navigator. 520 Chaining Allow unwatching of connections associated with Event Chains. 468 Chaining Chaining Enhancements. 461 Chaining Event Chain Node conditions such a failure, success, complete, etc. 501 Chaining Show chain glyph on calendar instances that are the result of a chain, and list chains in the calendar object popup. 500 Chaining Show Event Chain node in red when there has been at least one node failure. 431 Contacts Enable/Disable functions for users and groups. 368 Event Views Add an "All" option for each connection type to the 'Select Connections' screen. 247 Event Views Allow the user to add subfolders under 'Local Views', 'Shared Views' and 'Event Chains' folders. 455 Event Views Custom Event View -> Event Object Default Filters. 287 Filter Add a reset filter option. 395 General Add support for SQL Server 2005 Maintenance Plans. 418 General Ability to rewatch offline servers in order to access history. 509 General Add connection information to 'Show List' data. 485 General Add F1 shortcut to access the SQL Sentry User Guide. 454 General Collect additional information when unhandled exceptions occur. 524 General Warn users when SQL Server Agent Log is logging information status. 410 Graphs-Runtime 'Jump to Calendar' context item for runtime graphs. 420 Graphs-Runtime Popups for runtime graph bars. 328 MDI "Save Workspace" feature. 493 Navigator Add 'Refresh' context menu option for Event Views & Event Chains Navigator nodes. 496 Navigator Drag and drop objects into, out of and between folders in the Navigator. 373 Navigator New user preference to not show unwatched nodes as failed in Navigator. 415 Navigator Option to automatically clear failures if a subsequent run is successful. 510 Notifications-Messages Include host name & IP address in audit messages. 519 Objects-Actions Add 'Kill Task' action to appropriate Windows Scheduled Task conditions. 434 Objects-Conditions Allow regular expressions in OCM match strings. 515 Objects-Conditions Add 'Cluster Failover' condition. 44 Objects-Conditions Global block detection. 416 Objects-Conditions Sensitivity setting for SQL Server: Offline Condition. 465 Objects-Properties Add 'Open' context item for all openable nodes. 517 Objects-Properties Changes to 'Calculate Runtime Statistics Since' field should generate an audit alert. 523 Objects-Settings Auto-recycle SQL Server Agent Log setting. 419 Objects-Settings Prompt to load higher-level strings as default when enabling OCM condition at a lower level. 40 Performance Monitoring Long-running statement collection. 491 Reports Add parameter to reports to allow reporting on watched connections only. 482 Server-Service Create a Utility to change the SQL Sentry Server service login with out requiring a reinstall. 383 Setup Create a SQLSentry Jobs Category and automatically add all SQL Sentry jobs to this category when a server is initially watched. 486 Setup Dialog changes to public/private key entry form in the SQL Sentry setup. 443 Setup Install desktop icon to All Users profile. 172 User Preferences Add a new user preference, "Show jobs in categories", which would add a node for each job category. 494 User Preferences Give user option of selecting 'List View' as default instead of always defaulting to 'Calendar View'. ========================================================================================== FIXES: 1572 Auditing-Conditions Changing 'Calc Runtime Stats Since' does not fire 'Audit: Settings Changed' condition. 1750 Calendar view Exception: A generic error occurred in GDI+. 1699 Calendar view Exception: Close Running Event not implemented for this type. 1860 Calendar view Exception: The given key was not present in the dictionary. 1692 Chaining Duration for running node always reports 0 for running event chain. 1889 Chaining Event chains that run longer than the "Do Not Fire Actions For Messages Older Than" setting will not send email notificaitons. 1653 Chaining Exception: A transport-level error has occurred when receiving results from the server. 1849 Chaining Exception: Cannot generate SSPI context. 1720 Chaining Incorrect duration shown for lead chain node. 1753 Conflict Viewer Change to 'Conflicts Viewer' message box text. 1658 Console Synch Exception: Cannot generate SSPI context. 1733 Event Views Change title for event sources and filter dialogs on view creation screen. 1862 Event Views In create custom view, if you add connections, then click all SQL servers, select objects isn't enabled. 1951 Event Views Reset custom Event View not thread-safe. 1947 Event Views Resetting Event view to default sometimes causes stack overflow. 1730 Filter Exception occurs when filtering logs using a job name that contains a '. 1762 General Add text to 'Add Connection' window regarding default instances. 1276 General After SQL Sentry upgrade, SQL Agent Log entries no longer detected. 1953 General Deadlock grid doesnt show times for date/time detail columns. 1766 General Enable step detail parsing for SSIS sub type. 1603 General Exception: An item with the same key has already been added. 1899 General Exception: Cannot generate SSPI context. 1748 General Exception: Cannot generate SSPI context. 1938 General Exception: Collection was modified; enumeration operation may not execute. 1939 General Exception: Collection was modified; enumeration operation may not execute. 1922 General Exception: Data series for the Stacked Area chart can not have a different number of data points. 1880 General Exception: Exception of type 'System.OutOfMemoryException' wa 1773 General Exception: Incorrect syntax near 'Repository'. 1726 General Exception: Incorrect syntax near the keyword 'All'. 1970 General Exception: Index was out of range. Must be non-negative and less than the size of the collection. 1940 General Exception: Index was out of range. Must be non-negative and less than the size of the collection. 1929 General Exception: Object of type 'System.Int64' cannot be converted to type 'System.Int32'. 1891 General Exception: Specified cast is not valid. 1528 General Exception: The specified @alert_id ('10') does not exist. 1644 General Exception: Value cannot be null. 1791 General Exception: Value was either too large or too small for an Int32, 1248 General Make taskbar display any errors instead of showing in popups to reduce annoyance factor. 1758 General Oracle 10g EM backup job history lost after subsequent execution. 1706 General Misc Oracle bugs. 1920 General Fix issue with single quote in Windows Scheduled Task name. 1550 General Review Start -> Programs -> SQL Sentry 3.1 menu items. 1514 General UI does not include 'View' toolbar when window width is reduced. 1917 General User unable to launch console if his account was not used to install console originally & respository database is not installed on (local)->SQLSentry20. 1745 Graphs-Performance "Show Performance Graphs" context item is non-functional. 1890 Graphs-Performance Exception: Data series for the Stacked Area chart can not have a different number of data points. 1632 Graphs-Runtime Runtime aggregates graphs need to auto scale on X-axis. 1589 Licensing Exception: A transport-level error has occurred when sending the request to the server. 1909 List view Missing SSIS job step log records in list view. 1746 Logs Consolidate "Show ... Log" context items into one "Show Actions Log" 1670 Logs 'All Actions Log' filter searches on event time, not log time. 1738 Logs Exception: Line 1: Incorrect syntax near 'DB'. 1626 Logs Exception: Object reference not set to an instance of an object. 1735 Menus Rename Windows Scheduled Task context menu item has dissappeared. 1755 Menus Reports context menus are non-functional. 1711 Navigator Catch access denied errors when enumerating Windows Scheduled Tasks. 1707 Navigator Exception: A transport-level error has occurred when receiving results from the server. 1749 Navigator Exception: Cannot generate SSPI context. 1651 Navigator Exception: Cannot insert duplicate key row in object 'EventSourceObject' with unique index 'IX_EventSourceObject_EventSourceID_ObjectName'. 1934 Navigator Exception: Collection was modified; enumeration operation may not execute. 1686 Navigator Exception: EXECUTE permission denied on object 'sp_help_job', database 'msdb', schema 'dbo'. 1682 Navigator Exception: Object reference not set to an instance of an object. 1683 Navigator Exception: Object reference not set to an instance of an object. 1684 Navigator Exception: Object reference not set to an instance of an object. 1656 Navigator Exception: The given key was not present in the dictionary. 1871 Navigator Exception: The specified @alert_id ('90') does not exist. 1806 Navigator Exception: The specified @job_id ('B89679F1-B62D-475B-B790-9B..') does not exist. 1867 Navigator Exception: There is insufficient system memory to run this query. 1833 Navigator Exception: Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. 1886 Navigator Exception: Unknown WatchResult: Cancelled 1950 Navigator Navigation status updater anomolies and exceptions. 1716 Navigator Repeatedly selecting 'Show List' causes duplicate entries to be inserted in the results list. 1713 Navigator 'Start Chain' - context menu changes. 1721 Notes Exception: Object reference not set to an instance of an object. 1650 Notes Exception: Object reference not set to an instance of an object. 1761 Notifications Condition configuration controls are not fully visible by default. 1794 Notifications Duplicate notifications received for 'SQL Server Agent: Job Completed' condition. 1417 Notifications Ensure messages are delivered to SMTP server in chronological order. 1839 Notifications Manually deleting event chain objects from outside SQL Sentry does not trigger an 'Audit: Event Chain Modified' alert. 1813 Notifications-Messages <%StepName%> system parameter always reports name of first step regardless of which step failed. 1948 Notifications-Messages Extra line break in some messages. 1732 Notifications-Messages Remove extra section separator from end of all messages. 1954 Notifications-Messages Watched audit messages show invalid text. 1861 Objects-Actions Kill Task available at server level for job failure condition. 1681 Objects-Search Exception: Value cannot be null. 1590 Performance Monitoring Exception: An error has occurred while establishing a connection to the server. 1663 Performance Monitoring Exception: Could not locate Performance Counter with specified category name. 1884 Performance Monitoring Exception: Invalid object name 'PerformanceAnalysisSubsystemStatus'. 1646 Performance Monitoring Exception: Requested registry access is not allowed. 1356 Performance Monitoring Performance data collection issues for certain performance counters. 1573 Queuing Queue Indefinitely settings not honored for queued or queuing jobs. 1747 Queuing Queued objects may remain queued indefinitely. 1754 Reports Current Failures report doesn't show information for SQL Agent Error Log entries. 1882 Reports Exception: Arithmetic overflow error converting expression to varchar(). 1577 Reports Exception: Invalid column name 'Orderby'. 1729 Reports Exception: The item '/Customer Service/Development/xxxxxxxxxxx' cannot be found. 1927 Server-Connections Exception: Cannot generate SSPI context. 1709 Server-Service Exception: Cannot insert the value NULL into column 'dbname', table 'tempdb.dbo.#blockinfo. 1751 Server-Service Exception: Could not allocate space for object 'EventSourceHistory' in database 'SQLSentry20' because the 'PRIMARY' filegroup is full. 1731 Server-Service Exception: Incorrect syntax near 'ed'. Problem with unescaped query value. 1728 Server-Service Exception: Login failed for user 'sa'. 1695 Server-Service Exception: Unable to cast object of type 'System.DBNull' to type 'System.String'. 1838 Server-Service False-positive self blocking alerts. 1529 Server-Service Problem with multiple SQL Sentry Server service processes when SQLAgent log file too large. 1765 Server-Service sp_ReadLogFile_20 bug on SQL Server 2005 with SQL Agent error log messages over 1000 characters. 1742 Server-Service Uninstalling SSRS server & database without previously unwatching in SQL Sentry causes synchronization issues and prevents notifcations from being sent for that connection. 1952 Server-Settings Changing max rows to synchronize at the global level doesnt seem to work visually. 1756 Setup Need more informative error message during install. 1815 Setup Provide additional details during setup if server service installation fails. 1649 Setup Setup Wizard tries to watch connections that weren't selected after using the 'Back' button. 1956 Setup Wizard doesn't work correctly if you chose just to watch with EM. 1955 Setup-Upgrade Not all color defaults are set during upgrade from 3.x, leading to console crash. 1892 sp_sentry_mail Missing sp_sentry_dbmail_20 parameter. ========================================================================================== Change List SQL Sentry Event Manager Build 3.1.64.0 Date: 10/April/2008 ========================================================================================== FEATURES: ID Component Name 489 Server-Service Send notifications for 'Audit: Event Object Properties Modified' condition when changes made outside SQL Sentry. ========================================================================================== FIXES: ID Component Name 1900 Calendar view Recurring Monthly Jobs: Next instance does not display in the calendar 1879 Chaining Exception: Object reference not set to an instance of an object. 1881 Database Exception: Column or parameter #-3: Cannot find data type SYSNAME, Parameter '@CURRENTLANGUAGE' has an invalid data type. 1912 General Users without sysadmin rights cannot see running 2005 jobs 1897 General Poor query performance when synchronizing job step detail 1911 Navigator Performance issues when there are SQL Server groups and registrations 1877 Navigator Exception: [SQL-DMO]Maximum string length for this property or method is 32. 1718 Performance Monitoring Quick performance collection can create erroneous values ========================================================================================== Change List SQL Sentry Event Manager Build 3.1.56.0 Date: 17/January/2008 ========================================================================================== FIXES: ID Component Name 1823 Navigator Exception: You must have a parent form assigned prior to calling this method. 1836 Server-Service Exception: The query has been canceled because the estimated cost of this query (xxxxxx) exceeds the configured threshold of xxxxxx. 1847 General Exception: Could not perform the requested operation because the minimum query memory is not available. ========================================================================================== Change List SQL Sentry Event Manager Build 3.1.49.0 Date: 22/October/2007 ========================================================================================== FIXES: ID Component Name 1346 Notifications Max runtime messages stopped being generated after 24 hours. ========================================================================================== Change List SQL Sentry Event Manager Build 3.1.48.0 Date: 4/October/2007 ========================================================================================== FEATURES: ID Component Name 360 Calendar Show popups with description when you move over glyphs. ========================================================================================== FIXES: ID Component Name 1783 General Change position of slider on the actions pane(s) to show all contents above and below the control. 1743 Auditing-Conditions Object Created messages aren't always generated for new objects. 1315 Auditing-Conditions Actions Changed messages not generated consistently. 1717 Navigator Event source root nodes showing incorrect icons. ========================================================================================== Change List SQL Sentry Event Manager Build 3.1.45.0 Date: 21/August/2007 ========================================================================================== FIXES: ID Component Name 1714 Calendar View Manually starting a job places job in re-occuring tasks pane and shows incorrect 'Actual Duration'. 1740 Database Exception: Column or parameter #-3: Cannot find data type SYSNAME. ========================================================================================== Change List SQL Sentry Event Manager Build 3.1.44.0 Date: 20/June/2007 ========================================================================================== FIXES: ID Component Name 1715 General Expired records are not successfully purged from the history detail tables. ========================================================================================== Change List SQL Sentry Event Manager Build 3.1.43.0 Date: 14/June/2007 ========================================================================================== FEATURES: ID Component Name 425 Chaining In the search window for adding nodes, double clicking checks Add check box. 427 Chaining Add 'Edit Chain' context menu item instead of Edit button for chains. 456 Chaining Add 'Start Chain' to Event Chain context menu. 456 General Add 'Conflict Viewer' to the View menu. 456 General Add Calendar / List / Split view options to the View menu. 446 Menus Use Warning icon instead of Info icon for Delete Job Message box. 450 Navigator Show confirmation prompt after restarting SQL Agent service. 456 Navigator Add 'Watch All' and 'Unwatch All' to the context menu for the Devices node. 462 Navigator Show Confirmation Prompt When SQL Agent Service Started. 456 Objects-Search Modify the object search to only search watched connections. 456 User Preferences Add button to color preferences window to reset SQL Sentry back to its default color scheme. ========================================================================================== FIXES: ID Component Name 1705 Calendar view Running events on servers in different time zones are not normalized on the calendar. 1602 Calendar view Exception: Error creating window handle. 1645 Calendar view Exception: Parameter is not valid. 1613 Event Views Exception: Image cannot be added to the ImageList. 1689 General When starting a multi-step SQL Server Job, the job steps are displayed out of order. 1556 General Exception: Exception has been thrown by the target of an invocation. 1586 General Exception: The operation completed successfully. 1680 General Exception: Object reference not set to an instance of an object. 1675 Navigator Remove Event Chain General Actions from the SQL Servers node. 1587 Navigator Exception: Error creating window handle. 1591 Navigator Exception: Out of memory. 1654 Navigator Exception: Not enough storage is available to process this command. 1703 Navigator Exception: A connection was successfully established with the server... 1691 Notifications <%MessageText%> System Variable Returns incorrect information. 1698 Objects-Settings Settings time-popup controls always sets timespan value to seconds. 1669 Setup Trying to paste your private key password in the setup causes an exception. 1697 Server-Service Exception: Bei der Konvertierung eines char-Datentyps in einen datetime-Datentyp... 1676 Web Reports Modify Current Failures report to indicate times are displayed in UTC. ========================================================================================== Change List SQL Sentry Event Manager Build 3.1.41.0 Date: 16/May/2007 ========================================================================================== FEATURES: ID COMPONENT FEATURE NAME 298 General Add Show-->Audit Log and Show-->Event Log context items to instances on calendar and in navigator. 392 Licensing Update Checker & Licensing web app updates for software maintenance. 474 Navigator Show SQL Server version # in parens after connection name in Navigator. 466 Navigator Add "New" context items for Views, Chains, Users & Groups. 453 Server-Settings Maintenance windows for devices. 445 Server-Settings Automated cleanup of BlockData and ObjectConditionActionHistory tables. ========================================================================================== FIXES: ID COMPONENT DEFECT NAME 1605 Calendar/List view Running, multi-step jobs where calendar timeframe does not include start time of job. 1608 Calendar/List view Step callout is not visible on instances where the top of the event is not in view. 1616 Calendar view SQL Server Group Views only show events greater that one minute including failures. 1648 Chaining Changes To Start Chain Here Feature. 1633 Chaining Start Chain Here visible in context menu when chain is in the middle of executing. 1674 Chaining Event chain display problems when a node in a chain is a start node in another chain. 1643 Conflict Viewer Conflict Viewer changes. 1259 General Remote object version does not reflect actual version after watching server with an older version. 1332 General If Reporting Services DB is deleted for Event Source login failures occur. 1629 Licensing Nothing happens when watching a connection when there are insufficient licenses. 1671 Menus Save View As... menu item remains grayed out after closing all windows in Console. 1640 Navigator When editing registration properties, password is blank. 1641 Navigator Increase allowed length of SQL Server Name. 1444 Navigator Typos on "Connection Properties" forms. 1562 Navigator Issues when adding a new connection with the "Add as Watched" option. 1407 Notes Notes added to a future instance without selecting "Show For All Calendar Instances". 1638 Notifications SQL Server Agent Job: Run Missed condition not triggered when SQL Server or SQL Server Agent stopped 1568 Notifications-Messages Typo in Actions Changed messages for "Execute Process". 1596 Objects-Actions Log To Database action can delay processing of other actions. 1642 Objects-Properties Add "Last Statistics Collection Time" to object info screen. 1647 Setup Change in Setup Wizard - Detect permissions problems. ========================================================================================== Change List SQL Sentry Event Manager Build 3.1.33.0 Date: 9/Apr/2007 ========================================================================================== FEATURES: ID COMPONENT FEATURE NAME 464 General Create and Edit SQL Server 2005 Jobs and Alerts ========================================================================================== FIXES: ID COMPONENT DEFECT NAME 1623 Calendar view "Close Running Event" not functional for DTS packages 1627 Calendar view Jobs erroneously showing as conflicts 1634 Calendar view Can not stop running SQL Server Job 1635 Calendar view Calendar Doesn't Auto Refresh 1631 Filter Event source status not always accurately reflected in filter Event Sources dropdown 1636 Notifications Customers Receiving Job Monitor Error Notifications 1637 Notifications Job Blocking Notifications Not Working Correctly 1600 Setup-Upgrade Change default button to "No" for "Are you upgrading from version 2.0" prompt ========================================================================================== Change List SQL Sentry Event Manager Build 3.1.29.0 Date: 28/Mar/2007 ========================================================================================== FEATURES: ID COMPONENT FEATURE NAME ========================================================================================== FIXES: ID COMPONENT DEFECT NAME 1524 General Exception: A severe error occurred on the current command. 1606 Objects-Actions Duplicate Actions Created 1617 Setup Exception: Incorrect syntax near 'CONNE'. Problem installing when Windows username contains a "'". 1621 Setup-Upgrade Upgrade wizard may require growing database when there is enough room for new data 1622 Setup-Upgrade Upgrade wizard may exhaust system memory when processing neverending jobs 1620 User Preferences User Preferences may not render correctly on Windows Vista ========================================================================================== Change List SQL Sentry Event Manager Build 3.1.25.0 Date: 23/Feb/2007 ========================================================================================== FEATURES: ID COMPONENT FEATURE NAME 457 General Ad Support For Oracle EM Jobs ========================================================================================== FIXES: ID COMPONENT DEFECT NAME 1575 Calendar view Exception: Cannot insert duplicate key row in object 1604 Calendar view Running jobs show incorrect start time on CS servers. 1393 Chaining List boxes for Workflow window in Event Chains not alphabetized. 1556 General Exception: Exception has been thrown by the target of an invocation 1580 General Exception: The system cannot find the file specified 1262 Navigator When adding a connection for a device, Add as Watched checkbox does nothing. 1579 Navigator Exception: A generic error occurred in GDI+. 1465 Notifications-Messages Server Service: Settings Changed message formatting issues 1599 Objects-Properties Job Schedule Form throws errors when creating new schedule on 2005 SP2 CTP ========================================================================================== Change List SQL Sentry Event Manager Build 3.1.16.0 Date: 26/Jan/2007 ========================================================================================== FEATURES: ID COMPONENT FEATURE NAME ========================================================================================== FIXES: ID COMPONENT DEFECT NAME 1541 General License Entry dialog fixes 1550 General Changes to website icon in start menu 1554 General Jobs still show as running when SQL Server crashes, and "Run Missed" message generated. 1569 MDI Console can consume 100% cpu on Windows Vista under Aero 1571 MDI Some labels may be truncated on Windows Vista 1510 Navigator Visible Performance Counter icons don't change status when enabling performance monitoring for object 1559 Navigator Prevent deletion of computers device group node 1565 Navigator DTS node missing from some fresh 3.0 installs 1566 Navigator "Jump to time"" issues with 2005 Express instances. 1322 Notifications-Messages Changes to SQL Agent condition message formatting 1558 Objects-Search Blank space entered for object search field throws exception. 1570 Setup Uninstalling SQL Sentry on Windows Vista does not remove all start menu items ========================================================================================== Change List SQL Sentry Event Manager Build 3.1.9.0 Date: 10/Jan/2007 ========================================================================================== FEATURES: ID COMPONENT FEATURE NAME 394 General Support for SQL Server 2005 SSIS logging. 432 Performance Use "last modified" time when retrieving object records from remote sources. 1462 Setup Updates to setup wizard to simplify initial installation & configuration. ========================================================================================== FIXES: ID COMPONENT DEFECT NAME 1429 Calendar View Run Once scheduled events not appearing until they run. 1457 Calendar View Running jobs not displayed as running when SQLAgent is hung. 1328 Chaining Chain hangs when running during unexpected crash of server. 1426 Chaining Kill Action for Event Chain Runtime Threshold Max condition breaks chain. 1518 Chaining Event Chain Reset menu item not working reliably. 1456 Filter Bottom of event object categories listbox is truncated. 1419 General Changes/fixes to OCM strings config screen. 1491 General Exception: Out of memory. 1525 General Exception: An item with the same key has already been added. 1531 General Exception: SQL Server blocked access to procedure 'dbo.sp_get'. 1532 General Memory leak problem with Console. 1533 General Exception: The data is not valid. 1534 General Exception: Cannot access a disposed object.Object name: 'Add'. 1537 General Exception: Value of '121' is not valid for 'Value'. 1543 General Changes to the Send Test Email dialogs. 1544 General Cancelling Setup Wizard not prompting when dialog is closed using 'X'. 1545 General Support information dialog accessed from 'Add or Remove Programs'. 1305 Navigator Multi-server Jobs node showing as failed when there are no failures in the past x days. 1493 Navigator Navigator context item verification. 1542 Navigator Show History context item for SQL Agent log node. 1322 Notifications-Messages Formatting changes for SQL Agent condition messages. 1424 Objects-Actions Kill Task Action for Runtime Threshold Max condtion is fired twice. 1520 Objects-Actions Characters such as quotes in system parameters cause Action Failed for Execute Process actions. 1523 Objects-Conditions SQL Agent Offline not fired if a timeout is detected first. 1526 Objects-Conditions Event Chain Runtime Threshold Max Condition does not fire due to UTC conversion. 1501 Objects-Properties "Save" button not auto-enabled on Task props screen when "exit code" or "stop after" are changed. 1538 Setup Exception: Object reference not set to an instance of an object. 1539 Setup Test Email successful dialog returns control to the previous dialog. 1410 User Preferences Connect to Installation window always opens with Windows Auth Checked. 1515 Web Reports Report name "Performance Monitors List" changed to "Performance Counters List". ========================================================================================== Change List SQL Sentry Event Manager Build 3.0.32.0 Date: 04/Dec/2006 ========================================================================================== FEATURES: ID COMPONENT FEATURE NAME ========================================================================================== FIXES: ID COMPONENT DEFECT NAME 1395 Calendar view Running multi-step jobs showing incorrect start time on calendar after first step completes. 1503 Calendar view Extremely frequent DBMS Jobs causing unacceptable delay when rendering calendar views. 1499 Contacts-Users User email address containing apostrophe character is not valid 1512 General Notes node not displaying UTC date/time correctly 1502 Server-Connections DBMS Jobs that have never been run throw exception during object synchronization 1504 Setup-Migration Dialog not refreshing correctly when next/back buttons used with amount of history to migrate 1505 Setup-Upgrade v3 upgrade process time-out encountered 1506 Setup-Upgrade Problem with UTC date conversion ========================================================================================== Change List SQL Sentry Event Manager Build 3.0.31.0 Date: 21/Nov/2006 ========================================================================================== FEATURES: ID COMPONENT FEATURE NAME ========================================================================================== FIXES: ID COMPONENT DEFECT NAME 1494 Setup Service installation may fail on Windows 2000 ========================================================================================== Change List SQL Sentry Event Manager Build 3.0.29.0 Date: 16/Nov/2006 ========================================================================================== FEATURES: ID COMPONENT FEATURE NAME ========================================================================================== FIXES: ID COMPONENT DEFECT NAME 1484 Calendar View Left side of calendar may not render correctly if ClearType is enabled 1485 Setup Add/Remove programs does not have an icon for program. 1486 Setup Setup may fail if SQL Server credentials are used 1487 Setup Installing the service may return "Unable to load profile" error message ========================================================================================== Change List SQL Sentry Event Manager Build 3.0.23.0 Date: 10/Nov/2006 ========================================================================================== FEATURES: ID COMPONENT FEATURE NAME ========================================================================================== FIXES: ID COMPONENT DEFECT NAME 1479 Conflict Viewer Conflict Viewer gives no future instances in range msg unless looking at least 5 hours ahead. 1480 Conflict Viewer Conflict Viewer shows incorrect start/end times for some rows. 1467 General Text top is truncated on 'disable job until' msgbox. 1472 Graphs-Performance Performance Graph issues. 1465 Notifications-Messages Server Service: Settings Changed message formatting issues. 1481 Server-Connections Task Scheduler failsafe conditions not functioning correctly. ========================================================================================== Change List SQL Sentry Event Manager Build 3.0.21.0 Date: 03/Nov/2006 ========================================================================================== FEATURES: ID COMPONENT FEATURE NAME 440 Calendar View Enhanced calendar glyphs to show object status on the calendar. 1336 Connections SQL Server Authentication enhancements. 437 Filter Event Filter redesign. 45 General Oracle support. 412 General Performance re-architecture. 439 General Multiple time zone support. 441 General Connection specific logon credentials for users/server service. 407 Navigator Add "Clear Failed Status" back to Navigator context menus. 432 Optimization Use "last modified" time when retrieving records from remote sources. ========================================================================================== FIXES: ID COMPONENT DEFECT NAME 1388 Auditing Event Chain Modified condition issues. 989 Calendar View DTS events show up as In Progress perpetually. 1309 Calendar View Filter inconsistencies for MSX Calendar views. 1395 Calendar View Running multi-step jobs show on calendar with incorrect start time. 1405 Calendar View Dragging and dropping a scheduled instance from one day to another not working. 1439 Calendar View Completed events showing as In Progress on calendar. 1393 Chaining List boxes for Workflow window in Event Chains not alphabetized. 1359 Conditions History Monitor Errors occur when a connection is "offline". 1348 Contacts Users node doesn't update on clean install after wizard finishes. 812 Documentation DTS concurrent runs not handled correctly. 1228 General Modified RAISERROR statement in agent log reader proc. 1360 General Formatting fixes for SQL Sentry remote server job descriptions. 1367 General Events that run for longer than a day not showing days in the duration field. 1421 General Copy Job Wizard gives false success message when copying job. 1428 General Issues with SQL Agent log provider on 2005. 1430 General Agent tokens not enabled if an alert is auto-watched. 1478 General Console.exe process left running preventing the application to be started. 1219 List View TSX jobs showing on MSX connection view without instance name. 1350 List View Steps not always displayed for running DTS packages. 1392 List View One-time job schedules are not always displayed. 1427 Logs Message textbox is not cleared when a log record is not selected. 1322 Messages Formatting changes for SQL Agent condition messages. 1368 Messages Output Content Match message format issues. 1262 Navigator "Add as Watched" checkbox does nothing when adding a connection. 1422 Navigator New SQL Server Groups don't show in Navigator until restart. 628 Notifications False notifications & other issues caused by DST time changes. 1117 Notifications Server online/offline messages not sent if not monitoring any jobs. 1251 Notifications LogPerformanceData action can delay notifications. 1346 Notifications Task max runtime messages stopped being generated after 24 hours. 1408 Notifications Max runtime message includes details from previous run. 1396 Objects-Actions Send Page fails for entire group. 1411 Objects-Actions System Parameter Inconsistencies. 1240 Optimization Only query running events for connections returning objects. 1423 Preferences No Color in User Preferences for Stopped. 787 Queuing Verify that jobs resumed are auto-started if applicable. 1431 Settings Change default to 2 hrs for Msg Processor "Do Not Fire Actions for Messages Older Than" ========================================================================================== Change List sqlSentry Build 2.7.5.2 Date: 8/28/06 ========================================================================================== FEATURES: ID COMPONENT FEATURE NAME ========================================================================================== FIXES: ID COMPONENT DEFECT NAME 1415 General Date time conversion issues on non-english systems 1235 Graphs-Runtime Runtime Aggregates counts are too high 1273 Graphs-Runtime Missing bars on runtime graphs in multi-day views when using Days control. 1412 Queuing-Log Creating Queue Monitor job when sa account has been renamed 1413 Reports Schema updates for reports on Case Sensitive servers ========================================================================================== Change List sqlSentry Build 2.7.4.1 Date: 7/25/06 ========================================================================================== FEATURES: ID COMPONENT FEATURE NAME ========================================================================================== FIXES: ID COMPONENT DEFECT NAME 1406 Setup Exception when installing or upgrading repository on case sensitive server. ========================================================================================== Change List sqlSentry Build 2.7.3.3 Date: 7/7/06 ========================================================================================== FEATURES: ID COMPONENT FEATURE NAME ========================================================================================== FIXES: ID COMPONENT DEFECT NAME 1404 Console Synch Exception when synchronizing history with DTS. 1402 General Exception when using Log To Database Action with data that is out of range. 1403 Logs Exception when viewing logs with entries that are at extreme values. ========================================================================================== Change List sqlSentry Build 2.7.2.9 Date: 6/28/06 ========================================================================================== FEATURES: ID COMPONENT FEATURE NAME ========================================================================================== FIXES: ID COMPONENT DEFECT NAME 1399 sp_sentry_mail Invalid email addresses passed to sp_sentry_mail not handled properly. 1400 sp_sentry_mail sp_sentry_mail leaves some emails in a status of "Processing". ========================================================================================== Change List sqlSentry Build 2.7.2.7 Date: 6/27/06 ========================================================================================== FEATURES: ID COMPONENT FEATURE NAME ========================================================================================== FIXES: ID COMPONENT DEFECT NAME 1394 Navigator Source root node doesn't show in red with an object failure. 1397 Navigator Report jobs with null report name cause exception. ========================================================================================== Change List sqlSentry Build 2.7.2.4 Date: 6/15/06 ========================================================================================== FEATURES: ID COMPONENT FEATURE NAME 414 General Support for Standard Edition. ========================================================================================== FIXES: ID COMPONENT DEFECT NAME ========================================================================================== Change List sqlSentry Build 2.7.1 Date: 6/6/06 ========================================================================================== FEATURES: ID COMPONENT FEATURE NAME 377 Objects-Properties Add "Last Statistics Collection Time" to object info screen. ========================================================================================== FIXES: ID COMPONENT DEFECT NAME 1373 Calendar view Delete Job context item doesn't work for calendar instances. 1383 Calendar view All tasks are showing the "Close Running Event" context item. 1379 Chaining Add Rename Node context menu option for chain diagram. 1381 General Check for proc sp_is_sqlagent_starting before calling it. 1184 Graphs-Performance Task performance graph issues. 1389 Graphs-Performance "Jump to Next Instance Of" not working consistently for task. 1380 Logs Reporting Services jobs disappear after they run. 1385 MDI When viewing job information window, tab displays Description field instead of name. 1391 Objects-Conditions Remove Task Run Missed as a condition. 469 Server-Service Task scheduler monitor causes locking which breaks task scheduler. 1384 Web Reports SSRS Date Parameters don't support internationalization. ========================================================================================== Change List sqlSentry Build 2.7.0 Date: 5/15/06 ========================================================================================== FEATURES: ID COMPONENT FEATURE NAME 366 Calendar/List view Ability to copy contents of a grid cell to the clipboard. 391 Chaining Reporting Services enhancements. 399 Chaining Filter tab name formatting changes. 365 Filter Message when the actual rows returned for a source = "max rows to return". 346 General Show a consolidated log when clicking the Logs root node. 229 List view Add interval selector to "Jump to Time" screen. 369 Logs Add "Last Statistics Collection Time" to object info screen. 402 Logs Allow specifying success exit code for tasks. 403 Logs "Never treat as a Conflict" checkbox option. 376 Navigator Chaining enhancements 406 Navigator Graphical chaining configuration interface. 401 Notes Add "Add/Edit Notes" context item to connection nodes. 377 Objects-Properties Add a "Notes" column to the action logs. 382 Objects-Properties Make the "Page X" textbox editable. 386 Objects-Properties Add "Hide Unregistered Connections" option. ========================================================================================== FIXES: ID COMPONENT DEFECT NAME 904 Auditing-Conditions Duplicate object created messages when creating a job via the console. 1352 Auditing-Conditions Erroneous "Properties Modified" msgs generated when editing a task. 1364 Calendar view Changed "too much data" text for smallest interval. 1260 Event Views Selecting All Connections for Custom Event View adds all connections including unwatched... 1360 General Formatting fixes for sqlSentry remote server job descriptions. 1378 General SQL Server 2005 SP1 changes cause Alert Trap Job to fail. 1353 Graphs-Performance Settings not always being maintained for perf graphs on custom views. 1357 Graphs-Performance Jumping from a custom view event instance to a perf graph goes to wrong time. 1365 Licensing Server service "unwatches" connections for which you have licenses. 1363 Logs Invalid log pages count when record count is a multiple of 15. 1370 Logs Inconsistencies in Notes log column names and justification with respect to Action logs. 1361 MDI Issues with timeout msgbox when adding a new SQL connection. 1369 Notes Increase initial size of Notes editor, and persist last size and position. 1371 Objects-Search Object Search screen changes. 1356 Performance Monitoring Performance data collection issues. 1349 Setup User First Name to get autofocus on 2nd page of Quick Start Setup Wizard. 1362 Setup Database upgrades don't enforce exclusive access. ========================================================================================== Change List sqlSentry Build 2.5.6 Date: 2/23/06 ========================================================================================== FEATURES: ID COMPONENT FEATURE NAME 393 Auditing-Conditions Added system parameter for passing details for Audit and Failsafe Conditions ========================================================================================== FIXES: ID COMPONENT DEFECT NAME 1315 Auditing-Conditions Actions Changed messages not generated consistently. 1211 Calendar view Jobs Scheduled to Run Once showing up in future views after they ran. 1265 Calendar view Fixed issue with tasks forced to close after exceeding max execution time. 1297 Calendar/List view Failed task showing with success status on calendar. 1338 Calendar/List view SQL Agent Log "Warning" entries show a Run Status of "8". 1286 Chaining Horizontal scroll in Event Chain Designer only scrolls links. 1289 Conflict Viewer Use current Days value as default for "Show Conflicts Over X Days" value on Conflicts Viewer. 1307 Contacts Delete contact messagebox formatting issue. 1154 Event Views Enable "Show-->Performance Graphs" context items for monitorable event instances on custom views. 1244 General Standardized image for wizards. 1279 General If you install SQL Server 2000 DTS designer components after fresh 2005 install, errors with SQLNS. 1293 General Running task not closed properly after auto-termination warning. 1308 General Publish config to targets wizard updates. 1317 General Typo in exception reporter screen. 1319 General Starting a task that doesnt have valid properties set generates an exception. 1324 General Schedule synchronization fails on 2005 instances. 1334 General Icon changed for Connect To Installation… form. 1327 Licensing "License Key Mismatch" msgbox updates. 1243 Navigator Fixed issues with SQL Server registrations. 1264 Navigator Failed job not showing as red in Navigator. 1335 Navigator SQL Agent nodes showing invalid status. 1127 Notifications Multiple Runtime Threshold Max messages generated for same task. 1158 Notifications Run Missed messages being generated for future scheduled runs when agent comes back online. 1266 Notifications Task output message truncated when embedded double-quotes. 1306 Notifications Run Missed message generated for running job when SQL Server & Agent go offline. 1339 Notifications Job Runtime Max messages sent continuously after a Run Missed message. 1342 Notifications Fixed issues with task run missed & max runtime messages. 1345 Notifications Job Monitor "SQL Agent is starting" errors occur after SQL Agent comes back online. 1281 Notifications-Messages Audit message format fix. 1321 Notifications-Messages Formatting change for Output Content Match messages. 1322 Notifications-Messages Formatting changes for SQL Agent condition messages. 1323 Notifications-Messages General message formatting updates/fixes. 1333 Notifications-Messages Connection name prefix missing from job failure message. 1216 Objects-Conditions Max runtime events generated for tasks when TS service was offline. 1316 Objects-Conditions Output Content Match does not retain "Doesn't Exist" match condition. 1310 Objects-Properties Show "Disabled" as next run date in job info document if job is disabled 1326 Objects-Properties Remove "Date Modified" from DTS properties page. 80 Queuing Jobs still being queued/unqueued in the same pass. 787 Queuing Verify that jobs resumed by the queue monitor job will be auto-started if applicable. 941 Queuing Fixed issues when multiple queuing jobs are queuing a queued job. 943 Queuing Max queue size not always being honored. 951 Queuing Incorrect queuing job logged for queued job. 1195 Queuing Job queued past expected queue end time, and nothing logged. 1314 Queuing Increase queue start padding to 30 seconds. 1341 Queuing Queuing on case-sensitive SQL Server 2005 instances doesnt work. 1229 Server-Service EventHistoryMonitor needs to honor error resume interval for threadpool threads. 1343 Server-Settings Text change for Event Monitor tab. 1330 Setup Email confirmation from Quick Start Wizard returns SMTP password in plain text. 1337 Setup-Upgrade Changed text referring to uninstalling old version on upgrade to explain settings are retained. 1089 sp_sentry_mail sp_sentry_mail query results not formatted correctly. 1215 sp_sentry_mail sp_sentry_mail doesn't allow null message body. 1258 sp_sentry_mail sp_sentry_mail problems with attachement header. ========================================================================================== Change List sqlSentry Build 2.5.5 Date: 1/9/06 ========================================================================================== FEATURES: ID COMPONENT FEATURE NAME 390 MDI "Close All But This" context menu needed for documents. 387 Navigator Add "Create Devices from SQL Server Registrations" context menu to All Devices node. ========================================================================================== FIXES: ID COMPONENT DEFECT NAME 1106 Calendar view Step callout form changes. 1116 Calendar view When using "Jump to" context items, calendar first shows in 24hr view, then switches over to 1hr. 1236 Calendar view Update status bar for "retries" query. 1294 Calendar view Changes to "Jump To" behavior. 1295 Calendar view Default interval for view not always being honored. 1290 Conflict Viewer Change message box for Conflicts Viewer when in a history only view. 1288 General Error message box for update check/error report formatted incorrectly 1023 Navigator Issues with Unassigned group. 1103 Navigator "Jump to Next Instance" not working for recently re-enabled jobs. 1292 Navigator Deleting a 2005 registration that contains lowercase letters fails. 1304 Navigator Registered connections showing up in Unassigned node. 1311 Objects-Actions Manually started, unscheduled jobs that create a blocking condition not detected. 1140 Server-Service Unscheduled objects dont get monitored. 1071 Server-Settings Settings label fixes. 1303 User Preferences Issues with SQL Agent Alert tokens process. ========================================================================================== Change List sqlSentry Build 2.5.3 Date: 12/14/05 ========================================================================================== FEATURES: ID COMPONENT FEATURE NAME ========================================================================================== FIXES: ID COMPONENT DEFECT NAME 1284 Notifications sp_sentry_mail recipient lists ending in ; do not send correctly 1130 Event Views When deleting a view just created by save as..., the original view node disappears 1287 Notifications-Messages Object Queued and Dequeued messags include invalid End Time and Duration entries 895 Calendar View Object glyhs dont always display 1103 Navigator "Jump to Next Instance" not working for recently enabled jobs 1285 List View HTML Export of calendar list view formats HH:mm:ss times incorrectly ========================================================================================== Change List sqlSentry Build 2.5.2 Date: 12/8/05 ========================================================================================== FEATURES: ID COMPONENT FEATURE NAME ========================================================================================== FIXES: ID COMPONENT DEFECT NAME 1284 Notifications sp_sentry_mail recipient lists ending in ; do not send correctly 1128 Auditing-Actions No audit message when you change server service settings 1167 Security Roles If you have permissions to watch object, but not connection, error occurs when watching object. 1282 Navigator Exception thrown when creating new group registration if 2005 tools installed 1283 Navigator Exception thrown when editing server registration if 2005 tools installed 1049 Object search Context menu changes 1233 Server-Settings Frequency field in web reports grid doesnt allow consistent data entry. 1236 Calendar View Progress notification added for job retries query 1241 MDI When tabbing out of days control, dont change active document 1257 Objects-Properties "Stop the task if it runs for" on task info document doesnt display correct value. 1262 Navigator When adding a connection to a device, "Add as Watched" has no effect. 1263 MDI Site configuration window doesnt have scrollbars if window is too small. ========================================================================================== Change List sqlSentry Build 2.5.0 Date: 11/30/05 ========================================================================================== FEATURES: ID COMPONENT FEATURE NAME 9994 General Added support for SQL Server 2005. 9995 General Added support for running on 64-bit systems. 9996 General Several performance enhancements, especially for multi-processor machines. 9997 General Added Quick Start Setup Wizard. 9998 General Migrated to .NET Framework 2.0. 9999 General Previously unsupported performance counters work now due to Framework upgrade. ========================================================================================== FIXES: ID COMPONENT DEFECT NAME 1267 Calendar view Clicking on a running task in the all-day view generates an exception. 1270 Calendar view Instance text doesnt wrap after first line. 1271 Calendar/List view Zero duration historical task entries dont show up if running events are enabled. 1268 Contacts Adding a contact/group with name that already exists throws an exception. 1275 Licensing Cultures that use a date separator other than '/' do not load licenses correctly. 1256 List view Groupings cause grid to hang when there are a lot of events. 993 Logs Occasionally Condition dropdown not showing up for log filters. 1261 Navigator Adding a new shared view messes up the subnodes sorting. 1071 Server-Settings Settings label fixes. 1274 Toolbar "Days" label is being truncated on toolbar. ========================================================================================== Change List sqlSentry Build 2.1.21 Date: 11/4/05 ========================================================================================== FEATURES: ID COMPONENT FEATURE NAME ========================================================================================== FIXES: ID COMPONENT DEFECT NAME 1252 Chaining Chains fail intermittently with zero duration jobs. 1253 Setup Installation using SQL Authentication may fail if you do not also have windows authentication rights. 1249 Performance Graphs Rare IndexOutOfRangeException when loading performance graphs. 1250 Navigator Changing to settings from device registration node throws error. ========================================================================================== Change List sqlSentry Build 2.1.19 Date: 10/28/05 ========================================================================================== FEATURES: ID COMPONENT FEATURE NAME ========================================================================================== FIXES: ID COMPONENT DEFECT NAME 1239 Calendar view Index hint added to retry query. 1242 General Some SQL Exceptions cause error in error handler. 1237 List view Steps records do not load for DTS packages in list view. 1238 MDI Tab is being reused for object views. 1232 Notifications SMTP Authentication errors. ========================================================================================== Change List sqlSentry Build 2.1.18 Date: 10/17/05 ========================================================================================== FEATURES: ID COMPONENT FEATURE NAME 336 Auditing-Conditions New audit condition: "Notes Changed". 34 Calendar view Show effects of Execute Job on calendar. 142 Calendar view When dragging and dropping a job, show a small popup in upper left-hand corner. 299 Calendar view Show performance graph glyph on calendar for object instances that have monitoring enabled. 333 Calendar view Add operator and machine name fields to DTS popups. 341 Calendar view Add "Manually Close Event" context item to running DTS pkgs and Tasks. 375 Calendar/List view Add user pref for "Default days for Global and Group views". 307 Calendar/List view Persist the # of days, interval, and start time for each view. 321 Chaining Add sorting and start point icons for chains. 352 Contacts Show all configured notifications when clicking on the Contacts root node. 315 Event Views Context menu option "Set as default view". 271 Filter Apply "show " and "show related" as soon as clicked. 305 General Add a "Cancel" button to the synch warning msgbox. 317 General Append text to object deletion confirmation prompt text. 322 General Global handler for permissions related exceptions in the console. 332 General Incorporate data from sysdtstasklog into DTS step records. 337 General Interface to select which job step to run when starting a job, like E/M. 344 General Remoting interface for instantiating views. 303 Graphs-Runtime Group values into buckets for runtime aggregates graphs. 272 Licensing Ability for console and server to validate against hashed server name. 334 Licensing Add email address to Product Version Check paramters. 342 Licensing Remove server name from license checks for eval licenses. 259 Logs Add "Jump To" items to Event Log and Notes context menus. 318 Logs Add First and Last buttons to log navigation. 331 MDI Enable right-clicking a tab to close it without actually activating the tab. 257 Menus Add "Connect To Installation..." option to File menu. 81 Navigator Preset "Display for all" checkbox when adding a note from the navigator. 235 Navigator Rename windows tasks option. 279 Navigator Delete context item for maint plans. 312 Navigator Modifications to navigator auto-repositioning behavior. 335 Navigator Add Days selections to Show History context items. 345 Notes Clear failed status for all related objects. 55 Notifications Global setting to control how often runtime max threshold notifications are sent. 330 Notifications-Messages Add output text to historymonitor runtime min/max messages. 363 Notifications-Messages Add matching step output to "Output Content Match" condition messages. 310 Objects-Actions Add "objecttype" and "condition" system parameters to Execute actions. 353 Objects-Actions New color scheme for enabled/disabled actions. 19 Objects-Properties Add Alerts section to job information window which lists any alerts linked to a job. 237 Objects-Search Add "Properties" context item for jobs, maint plans, alerts, tasks, etc. 263 Objects-Search Add enable/disable/delete/properties/watch context items to object search. 284 Objects-Search Add Owner as a search option. 313 Performance Monitoring Different retention setting for performance data. 35 Queuing Queued jobs continually repositioned on every refresh. 261 Server-Service Need to cleanup history tables on the target servers. 92 Server-Settings Allow "maintenance window" schedule settings for each server or globally. 264 Server-Settings Move "Run Missed" settings to source level. 265 Server-Settings Add checkbox to SMTP settings "Enable SMTP logging for notifications. 325 Setup Setup proc which mirrors the initial "quick start" process. 372 Setup Add LogToDatabase actions for all failsafe conditions on initial install. 358 Toolbar Add "Jump To Time" context item for all nodes above the object level. 324 User Preferences Add user pref "Single-click to open tab" to Navigator sections. 266 Web Reports Additional web reports. ========================================================================================== FIXES: ID COMPONENT DEFECT NAME 717 Auditing-Conditions Disabling/enabling a job does not trigger an audit entry. 904 Auditing-Conditions Duplicate object created messages when creating a job via the console. 939 Auditing-Conditions Auditing "Settings Changed" condition doesn't capture all changes to actions. 642 Calendar view Future calendar events starting before current time don't display. 667 Calendar view Schedule status not accurate in popups. 786 Calendar view Issue with in-progress DTS pkgs and Tasks not showing as running in all views. 808 Calendar view Issue with future instances of jobs set to run on X day of the month. 882 Calendar view Add "Actual Duration" to popups for running events. 900 Calendar view Doubling of calendar events on views that go across midnight. 901 Calendar view Format change for maint plan instances. 910 Calendar view Remove extra linefeed after last schedule in popups. 912 Calendar view "Current Time" popup innacurate in 24hr & 4hr views. 915 Calendar view Subnodes not always available for "Show-->Performance Graphs". 934 Calendar view Invalid % of average showing for report instances. 940 Calendar view Issue when dragging and dropping an instance whose start time is before the current range. 961 Calendar view Change "Step Output" to "Last Step Output" in popups. 965 Calendar view Running DTS packages sometimes extend past the current time. 971 Calendar view Rare exception when loading calendar. 973 Calendar view DTS step details not showing the latest data for running packages. 996 Calendar view Stop/Start/Enable/Disable Task does not work from calendar events. 997 Calendar view Stop Task command causes orphaned In-progress record on calendar. 1005 Calendar view Lack of proper locking causing collection modified errors. 1013 Calendar view Jobs missing from recurring jobs pane in 1hr and 4hr views. 1015 Calendar view Remove Start Time and End Time section from instances in the recurring pane. 1026 Calendar view Duplicate jobs showing on calendar. 1027 Calendar view When opening a new view, days left/right is zero. 1041 Calendar view Exception: Collection was modified; enumeration operation. 1052 Calendar view Job set to start with SQLAgent showing on calendar in current time view. 1053 Calendar view Popup issues for instances in recurring window. 1065 Calendar view "Show" context items on calendar instances not working when in "double-click to open tab mode". 1066 Calendar view Jobs are showing in recurring window in historical views. 1068 Calendar view Recurring jobs show no status. 1085 Calendar view Add/Edit notes from running instance throws exception. 1090 Calendar view Status errors for ongoing jos. 1108 Calendar view Always show running jobs in the recurring pane in historical views. 1148 Calendar view When in a future-only interval, then zooming out to 24hrs, no history is shown. 1149 Calendar view Calendar does not honor start/end date for job schedules. 1150 Calendar view Duplicate instances being displayed sometimes in future intervals. 1155 Calendar view Calendar doesnt do a sync on refresh when running job is in view. 1165 Calendar view Failsafe Action pane becomes available when clicking on another instance of the same object. 1172 Calendar view Some future instances of recurring jobs with "inverted" schedules not being displayed on calendar. 1174 Calendar view Drag-and-drop not refreshing correctly to reflect schedule changes. 1185 Calendar view Future tasks not showing in recurring window. 1187 Calendar view Running tasks don't show on calendar when a runtime filter is applied. 1210 Calendar view Show Runtime Graphs menu option throws exception from running calendar instance. 897 Calendar/List view Don't load history for DTS, maint plans, or other "history only" providers when in a future view. 1114 Calendar/List view "Show History" process issues. 1171 Calendar/List view Calendar appears to be cycling through the load process multiple times in history-only views. 1197 Calendar/List view Detail rows assigned to wrong DTS package on concurrent runs. 1070 Chaining Vertical scrollbar for Links section of Event Chain Editor. 1082 Chaining Chaining UI issues. 1086 Chaining Exception when saving chain with empty link. 959 Conflict Viewer Add connection name column to conflicts resolver. 1050 Conflict Viewer Conflict Viewer formatting changes. 960 Console Synch Synch prompt references incorrect connection name. 1096 Console Synch Deleting an object on the remote system causes the console to try to delete it again if it synchs. 1051 Contacts User/Group notifications grid changes. 1194 Contacts Condition/action groupings for a User being reused for other objects. 1169 Contacts-Users Save button not enabling when email or pager address is changed for an existing user. 902 Database Widen fields which store Task Scheduler metadata. 974 Database Wildcard syntax error in remote job query. 1083 Database Reporting Services synchronization throws exception for reports with long parameters. 1162 Database Changing to Windows Auth from SQL Auth on same repository doesn't register. 1088 Event Views LiteSpeed Sample view text filter changes. 1129 Event Views When doing a "Save As" with a view with attached monitors, monitors aren't transferred to new view. 1137 Event Views "Select Objects" screen issues. 1183 Event Views Names for system views (what shows up in tab) need to be dynamic. 1189 Event Views "Set Filters" formatting issue. 1191 Event Views Creating a new view and enabling future events before setting view name causes exception. 780 Filter Filter behavior mod when explicitly selecting an object. 827 Filter Verify multiple keyword functionality is working for filters. 883 Filter Running jobs not visible when using a runtime filter. 921 Filter Remove Filter button should be disabled if Apply Filter button is not blue. 986 Filter Do not perform step text filter queries for sources that don't have steps. 987 Filter Event Objects lists on filter tabs for custom event views shows all objects. 1036 Filter Changes to Sources tab. 1056 Filter Fix tab order on General and Sources filter tabs. 1072 Filter "Remove Filter" is disabled on device nodes, but "Apply Filter" is not applied by default. 1112 Filter General tab formatting issues. 1147 Filter Remove "Servers:" label from connections list on Sources tab. 1200 Filter Filter Description changes. 1201 Filter Filter Property tab issues. 726 General Win2k3 SP1 Generates Unhandled Exceptions when user doesnt have rights to SQLServer. 898 General Duplicate server names showing up in "Copy job to..." wizard. 899 General Errors when selecting not to overwrite existing jobs with copy job wizard. 947 General Exception when closing update checker while checking for updates. 976 General Schedules that run once have invalid description. 979 General Error when synchronizing job history if no data in remote table. 983 General Exception when adding server registration. 990 General Updates to warning messagebox used when saving view with no objects. 991 General Compromised functionality when installing SP3 or greater after watching a server. 992 General Ensure that PreSP3 objects are upgraded to PostSP3 if the server version changes to PostSP3. 1010 General Do not poll unwatched connections. 1038 General Exception: Cannot access a disposed object named "SoftwareUpd..." 1078 General Status bar text updates. 1087 General Change sample views to leverage new Source Filters. 1102 General Fixes for Enable/Disable prompts. 1105 General Only allow sql-ns operations against sql server 7.0 or 2000. 1182 General Delete context menu not available for tasks. 1193 General Runtime stats dont calculate correctly. 1214 General Optimizations which decrease memory utilization for the Server service. 9 Graphs-Performance Performance graphs move when there is new performance data, should only move on new job data. 43 Graphs-Performance Missing bars on right edge of perf graphs. 916 Graphs-Performance "Show value labels" setting not being persisted when changing performance monitors for an object. 1008 Graphs-Performance Issues with performance graphs and views with explicitly linked objects. 1067 Graphs-Performance Incorrect default interval used when jumping to a performance graph from calendar instance. 1110 Graphs-Performance Auto-scale to max option is not persisted by perf graphs if it is changed on a runtime graph. 1134 Graphs-Performance Decimals not accepted by Min/Max Y Val controls on perf graphs. 1135 Graphs-Performance "Show Live Data" not working. 1184 Graphs-Performance Task performance graph issues. 701 Graphs-Runtime Increase days limit for runtime graphs. 953 Graphs-Runtime Refresh issues with runtime graphs. 962 Graphs-Runtime Increase max records for runtime graphs. 967 Graphs-Runtime Go To time controls should not change the current interval or days when used on a graph. 1076 Graphs-Runtime Max/Min Y Val controls are enabled when Auto-scale to Max is enabled on first load. 1104 Graphs-Runtime Invalid Interval runtime stats. 994 List view When expanding a job in the List View, refresh collapses all nodes. 820 Logs Invalid condition name being logged for DTS. 914 Logs Event Logs dont resize combo boxes correctly. 982 Logs Exception sometimes when opening history log view. 1002 Logs Multiple Log Filter Issues. 1045 Logs "Jump To" context menu items missing from Event Logs. 1058 Logs Update status bar and/or show hourglass when paging through logs. 1142 Logs Add blank entry at top of log filter dropdowns. 1143 Logs Change date filters to use "Log Time" versus "Event Time". 1146 Logs Log Performance Data condition available in service logs. 229 MDI when changing from job to job, it goes to the global view, then back. 889 MDI Change all "Jump to Instance" context items to "Jump to Calendar". 937 MDI Prevent refresh of actions & settings when a different instance of the same object is selected. 954 MDI Remove "Runtime" from runtime graph tab names. 1000 MDI Enable opening of multiple log tabs simultaneously. 1092 MDI Actions & Settings pane not staying in synch with selected node. 920 Menus Ensure View menu options are consistent with tab names. 1003 Menus Changes to View Queue Log context menu item. 1033 Menus Context menu fixes/updates. 1157 Menus Disable Task Until... Context Menu Item missing from Tasks in Navigator. 783 Multi-server Admin Filter local MSX jobs from Multi-server job view. 580 Navigator Disable Alert not working. 658 Navigator Add "watch job" context items to individual maint plan nodes. 682 Navigator Navigator window not always auto-hiding. 719 Navigator When changing a group for a device, nodes are lost. 790 Navigator Icon and context menu mods for monitored event views. 913 Navigator Right clicking on a task node and selecting stop when it is stopped generates an exception. 922 Navigator Deleting a SQL Server registration from Devices throws error. 950 Navigator Tasks dont show enabled/disabled status in treeview. 955 Navigator Unwatching then watching a connection removes all object nodes. 957 Navigator Reporting Services Jobs sometimes show as GUID in Nav Pane. 984 Navigator New folder icon for Logs root node. 995 Navigator Sort custom event view nodes alphanumerically. 1018 Navigator Exception: Object reference not set to an instance of an object. 1079 Navigator Using Jump to Navigator context when Nav Pane is auto-hidden. 1097 Navigator Watch All Objects should not be available at the connection level if the connection is not watched. 1098 Navigator Deny watching SQL 2005 instances. 1113 Navigator Adding multiple device nodes with the same name throws exception. 1122 Navigator Watched servers that are not migrated have "watch all objects" menu options. 1159 Navigator Event Source Object Nodes dont change disabled X to red when going from disabled to disable until. 1160 Navigator Add disable until icons for tasks and alerts. 1199 Navigator Exception when selecting device registration node that has no connections. 933 Notes Adding a note from the event log to a failed instance does not ask to clear failure. 1016 Notes Vertical scrollbar for Note listbox on Add/Edit Notes form. 1046 Notes Make default Notes field Title. 1093 Notes When clicking Add/Edit Notes from Event Log, most recent note opens for editing instead of new note. 1111 Notes "Show for all Calendar instances" checkbox is preselected when adding a note from a log entry. 1166 Notes "Show for all instances" pre-selected when adding a note to a future instance. 670 Notifications No server service exception notifications sent when the sqlsentry database server was stopped. 699 Notifications Don't send runtime notiifcations until we have data. 723 Notifications Duplicate "server online" messages. 864 Notifications Multiple missing Run Missed events. 888 Notifications DTS failure messages returning incorrect step. 988 Notifications When database is offline, risk of overflowing action failed (log to db) messages. 1014 Notifications HistoryMonitor message not generated for max runtime condition. 1084 Notifications Output Content Matches do not update when condition criteria is changed. 1124 Notifications Connection Migration messages not working. 1127 Notifications Multiple Runtime Threshold Max messages generated for same task. 1176 Notifications SMTP logging not working for pager messages. 1188 Notifications HistoryMonitor max runtime message not always being generated for tasks. 1205 Notifications "Windows Task: Completed" condition not firing. 692 Notifications-Messages Audit message format issues. 714 Notifications-Messages Blocking message format issues. 936 Notifications-Messages Min Runtime and Threshold messages seem ambiguous by using "exceeded". 942 Notifications-Messages "Action Failed" message formatting changes. 958 Notifications-Messages Invalid attachment filename causes Email Monitor to stop processing emails. 945 Notifications-Messages Dual Job Started Notifications being generated. 948 Notifications-Messages Job Monitor "Started" Notifications include incorrect End Time. 1006 Notifications-Messages Disable Until notifications should either give local time or specify UTC. 1012 Notifications-Messages Notes section heading missing from messages. 1021 Notifications-Messages Format updates for Output Content Match messages. 1022 Notifications-Messages History synchronization error message formatting issues. 1069 Notifications-Messages "Step Failed" condition message format change for Job and DTS Pkg step failures. 1081 Notifications-Messages Remove "End Time" from Job/Task Monitor max runtime messages. 1139 Notifications-Messages SQL Agent Alert message formatting issue. 1173 Notifications-Messages "Notes Changed" audit message formatting issues. 1177 Notifications-Messages Alert Content Match Message Issues. 1178 Notifications-Messages When disabling/enabling a job audit messages don't include relevant info. 1192 Notifications-Messages Inconsistency in naming for "Actions Changed". 952 Objects-Actions Send Email/Page targets not saving when changing jobs. 1030 Objects-Actions On Console startup, Actions and Settings pane is blank. 1131 Objects-Actions Sql alert output content match condition at server and global level. 1144 Objects-Actions Job Output Content Match Condition has erroneous Action. 1153 Objects-Actions Kill Job Action on Runtime Threshold Max Condition fails. 854 Objects-Conditions Add DTS Step Failure Condtion. 866 Objects-Conditions Invalid max runtime events for tasks. 880 Objects-Conditions Erroneous max runtime condition for manually started job. 927 Objects-Conditions Invalid Run Missed message generated. 1035 Objects-Conditions Remove "Save Changes" msgbox when clicking Cancel on Output Content Match screen. 1054 Objects-Conditions Erroneous "Run Missed" messages being generated. 1141 Objects-Conditions "Output Content Match" issues. 1151 Objects-Conditions SQL Server Agent Job: Started Condition has Kill Task Action at Global Level. 1168 Objects-Conditions Update to string for Output Content Match Condition at object is applied globally. 645 Objects-Properties Middle justify the HH:MM:SS label with the controls, versus bottom justifying. 963 Objects-Properties Exception when synchronizing job steps if the step has no command text. 1049 Objects-Search Object Search context menu changes. 1156 Objects-Search When selecting Delete for a job, then hitting Cancel, the record disappears from the results list. 703 Objects-Settings Ensure consistent settings ordering. 970 Objects-Settings Settings selector list not populated for computer nodes. 1004 Objects-Settings Settings dropdown list changes. 1019 Objects-Settings Exception: Object reference not set to an instance of an object. 1064 Objects-Settings Object name can be truncated in Settings object selector listbox. 905 Performance Monitoring Performance collection error when adding a 2nd job with the same counter. 926 Performance Monitoring Right click allows unwanted dragging of Performance Graphs. 980 Performance Monitoring Add Source Text filters to view which will apply also adding performance counters to jobs. 1203 Performance Monitoring Server name isn't pre-populated when adding performance monitors to a task. 1204 Performance Monitoring Add Performance Monitors screen issues. 754 Performance Optimizing Optimize query used to pull perf counters for a view. 869 Performance Optimizing Target query optimization opportunities. 1179 Performance Optimizing Query optimization - pre-cast binary query criteria. 650 Printing Issues with "Print Options" screen. 871 Server-Service EventHistoryMonitor error: Subquery returned more than 1 value. 1075 Server-Service Run missed not working when SQL Server Agent goes offline. 1071 Server-Settings Settings label fixes. 1120 Server-Settings Save button is not enabled when changing the value of "Send Performance Threshold Notification..." 534 Setup Select previous database error doesn't indicate if the selected database doesn't actually exist. 779 Setup Eval expiration prompt. 1048 Setup Installing Console only on fresh install bypasses check for DB. 1180 Setup-Migration Migration script can fail if some objects are missing. 1138 Setup-Upgrade Negative statistics values are created when upgrading from 1.2. 1025 sp_sentry_mail Interim state for emails sent through sp_sentry_mail to prevent multiple dupes. 1061 sp_sentry_mail Missing results attachment when using sp_sentry_mail_20. 1207 sp_sentry_mail sp_sentry_mail fails if attachment query contains rows with null value for any field in the first record. 1031 Toolbar Missing Nav Toolbar when clicking back to Calendar view tab. 1059 User Preferences User Preferences issues. 975 Web Reports Error when saving web report directory. 1152 Web Reports Web Reports using instance name instead of machine name.