SQL Server Management Studio 歷史版本列表
更新時間：2019-08-13
更新細節：
What's new in this version:
- Distorted text in text form field (overlapping characters)
- Context menu of form field disappears after a short period of time
- Text get's clipped after TLines are made
- Form editing gets interrupted as soon as tooltip is shown
- Better support for styled checkboxes and radio buttons
- Form field settings get discarded after revisiting the "Properties" dialog
- text changes colour after translation import
- Checkboxes created by Infix don't check/uncheck correctly in Adobe Reader
- Eliminated bogus 'loading bookmarks...' error when opening certain PDFs
- Auto-fit facility was not working correctly in Translate->Local->Import
- interactive form Buttons with icons were not be dealt with correctly
- underlines being inferred incorrectly
- PDF text rendered incorrectly
- backslash disappears when searching and replacing.
- better display of text from TextMaker & PlanMaker from SoftMaker
- Improved display of text added via Bates numbering (font errors)
- Better handling of excessively clipped text - better display and faster editing
- Cannot copy/paste form fields during forms editing
- Tooltips of form objects don't get shown
- Text spacing could be wrong when using multi-byte fonts
- signature image could be wrong size small when inside a form element
- Possible crash when editing a document with TextPlus
- Possible crash when opening PDFs containing very long names
- Better handling of filename with trailing spaces (Windows)
- Text displayed in wrong position if using the 'cm' operator for positioning
- Better handling of PDF with bogus pages
- Coloured pattern doesn't get shown
- Cancel button missing from dialog on Mac during auto-translation
- Possible crash when checking for an active license on start-up
- Missing translation could cause problems using TransPDF from within non-English versions
- Possible crash when doing form editing using German user-interface
- zoom tool not working
更新時間：2019-08-01
更新細節：
What's new in this version:
Important note:
- Due to removal of compatibility with old version passwords in this version, downgrading to any version prior to v6.43 (v6.42.12 and older) will clear all user passwords and allow password-less authentication. Please secure your router after downgrading.
- Old API authentication method will also no longer work, see documentation for new login procedure
- Certificate: renew certificates via SCEP when 3/4 of lifetime reached
- Crs317: fixed multicast packet receiving (introduced in v6.45)
- Hotspot: fixed default profile values not being used (introduced in v6.45)
- Rb4011: fixed SFP+ interface linking (introduced in v6.45.2)
- Smips: reduced RouterOS main package size (disabled LTE modem, dot1x and SwOS support)
- Supout: fixed SIM slot printing (introduced in v6.45)
- Wireless: improved U-APSD (WMM Power Save) support for 802.11e
更新時間：2019-07-25
更新細節：
What's new in this version:
New:
- New Item Details
- Intellisense/Editor Added support for Data Classification
- OPTIMIZE_FOR_SEQUENTIAL_KEY Added Intellisense support
- OPTIMIZE_FOR_SEQUENTIAL_KEY Turns on an optimization within the database engine that helps improve throughput for high-concurrency inserts into the index. This option is intended for indexes that are prone to last-page insert contention, typically seen with indexes that have a sequential key such as an identity column, sequence, or date/time column. See CREATE INDEX for more details
- Query Execution or Results Added a Completion time in the messages to track when a given query completed its execution. See UserVoice for more details
- Query Execution or Results Allow more data to be displayed (Result to Text) and stored in cells (Result to Grid). SSMS now allows up to 2M characters for both (up from 256 and 64K, respectively). This also addressed the issue of users not able to grab more than 43680 chars from the cells of the grid
- ShowPlan Added a new attribute in QueryPlan when inline scalar UDF feature is enabled (ContainsInlineScalarTsqlUdfs)
- SMO Added support for Feature Restrictions. For more information on the feature itself, see Feature Restrictions
- Integration Services (SSIS) Perf optimization for SSIS package scheduler in Azure
Bug fixes:
- New Item Details
- Accessibility Updated the XEvent UI (the grid) to be sortable by pressing F3
- Always On Fixed an issue where SSMS was throwing an error when trying to delete an Availability Group (AG)
- Always On Fixed an issue where SSMS was presenting the wrong failover wizard, when replicas are configured as Synchronous, when using read scale AGs (cluster type=NONE). Now, SSMS presents the wizard for Force_Failover_Allow_Data_Loss option, which is the only one allowed for cluster type NONE Availability
- Always On Fixed an issue where the wizard was restricting the number of allowed synchronizations to three
- Data Classification Fixed an issue where SSMS was throwing an Index (zero-based) must be greater than or equal to zero error when trying to view data classification reports on databases with CompatLevel less than 150.
- General SSMS Fixed an issue where the user was unable to horizontal scroll Results pane via mouse wheel. See UserVoice for more details
- General SSMS Updated Activity Monitor to ignore benign wait types SQLTRACE_WAIT_ENTRIES
- General SSMS Fixed an issue where some color options (Text Editor > Editor Tab and Status Bar) were not persisted. See UserVoice
- General SSMS In connection dialog, replaced Active Directory - Universal with MFA support with Azure Active Directory - Universal with MFA (functionality is the same, but hopefully it's less confusing)
- General SSMS Updated SSMS to use correct defaults values when creating an Azure SQL Database
- General SSMS Fixed an issue where the user was not able to Start PowerShell from a node in Register Servers when the server is a SQL Linux container
- Import Flat File Fixed an issue where Import Flat File was not working after upgrading from SSMS 18.0 to 18.1. See UserVoice
- Import Flat File Fixed an issue where Import Flat File Wizard was reporting a duplicate or invalid column on a .csv file with headers with Unicode characters
- Object Explorer Fixed an issue where some menu items (for example, SQL server Import and Export Wizard) where missing or disable when connected to SQL Express. See UserVoice for more details
- Object Explorer Fixed an issue which was causing SSMS to crash when an object is dragged from Object Explorer to the editor. See UserVoice for more details
- Object Explorer Fixed an issue where renaming databases was causing incorrect database names to show up in Object Explorer. See UserVoice for more details
- Object Explorer Fixed a long outstanding issue where trying to expand the Tables node in Object Explorer for a database which is set to use a collation that is not supported by Windows anymore triggers an error (and the user can't expand his or her tables). An example of such collation would be Korean_Wansung_Unicode_CI_AS
- Register Servers Fixed an issue where trying to issue a query against multiple servers (under a Group in Registered Servers) when the Registered Server uses either Active Directory - Integrated or Azure Active Directory - Universal with MFA did not work because SSMS failed to connect
- Register Servers Fixed an issue where trying to issue a query against multiple servers (under a Group in Registered Servers) when the registered server uses either Active Directory - Password or SQL Auth and the user chose not to remember the password would cause SSMS to crash
- Reports Fixed an issue in Disk Usage reports where the report was failing to when data files had a vast number of extents.
Replication Tools Fixed an issue where Replication Monitor was not working with publisher DB in AG and distributor in AG (this was previously fixed in SSMS 17.x
- SQL Agent Fixed an issue that when Adding, inserting, editing or removing job steps, was causing focus to be reset the first row instead of the active row. See UserVoice for more details
- SMO/Scripting Fixed an issue where CREATE OR ALTER was not scripting objects that had extended properties on them. See UserVoice for more details
- SMO/Scripting Fixed an issue where SSMS wasn't able to script CREATE EXTERNAL LIBRARY correctly
- SMO/Scripting Fixed an issue where trying to run the Generate Scripts against a database with a few thousand tables (was causing the progress dialog to appear to be stuck
- SMO/Scripting Fixed an issue where scripting of External Table on SQL 2019 did not work
- SMO/Scripting Fixed an issue where scripting of External Data Source on SQL 2019 did not work
- SMO/Scripting Fixed an issue where extended properties on columns were not scripted when targeting Azure SQL DB
- SMO/Scripting Last-page insert: SMO - Add property Index.IsOptimizedForSequentialKey
- SSMS Setup Mitigated an issue where SSMS setup was incorrectly blocking the installation of SSMS reporting mismatching languages. This could have been an issue in some abnormal situations, like an aborted setup or an incorrect uninstall of a previous version of SSMS. See UserVoice for more details
- XEvent Profiler Fixed a crash when the viewer is being closed
更新時間：2019-07-19
更新細節：
What's new in this version:
- Due to removal of compatibility with old version passwords in this version, downgrading to any version prior to v6.43 (v6.42.12 and older) will clear all user passwords and allow password-less authentication. Please secure your router after downgrading
- Old API authentication method will also no longer work, see documentation for new login procedure
- Bonding - fixed bonding running status after reboot when using other bonds as slave interfaces (introduced in v6.45)
- Cloud - properly stop "time-zone-autodetect" after disable
- Interface - fixed missing PWR-LINE section on PL7411-2nD and PL6411-2nD (introduced v6.44)
- Ipsec - added "connection-mark" parameter for mode-config initiator
- Ipsec - allow peer argument only for "encrypt" policies (introduced in v6.45)
- Ipsec - fixed peer configuration migration from versions older than v6.43 (introduced in v6.45)
- Ipsec - improved stability for peer initialization (introduced in v6.45)
- Ipsec - show warning for policies with "unknown" peer
- Ospf - fixed possible busy loop condition when accessing OSPF LSAs
- Profile - added "internet-detect" process classificator
- Radius - fixed "User-Password" encoding (introduced in v6.45)
- Ssh - do not enable "none-crypto" if "strong-crypto" is enabled on upgrade (introduced in v6.45)
- Ssh - fixed executed command output printing (introduced in v6.45)
- Supout - fixed supout file generation outside of internal storage with insufficient space
- Upgrade - fixed "auto-upgrade" to use new style authentication (introduced in v6.45)
- Vlan - fixed "slave" flag for non-running interfaces (introduced in v6.45)
- Wireless - improved 802.11ac stability for all ARM devices with wireless
- Wireless - improved range selection when distance set to "dynamic"
更新時間：2019-07-12
更新細節：
更新時間：2019-07-01
更新細節：
What's new in this version:
Important note:
- Due to removal of compatibility with old version passwords in this version, downgrading to any version prior to v6.43 (v6.42.12 and older) will clear all user passwords and allow password-less authentication. Please secure your router after downgrading
Changes:
- added support for IEEE 802.1X Port-Based Network Access Control
- added support for EAP authentication methods (eap-tls, eap-ttls, eap-peap, eap-mschapv2) as initiator
- removed insecure password storage
- correctly display bridge FastPath status when vlan-filtering or dhcp-snooping is used
- correctly handle bridge host table
- fixed log message when hardware offloading is being enabled
- improved stability when receiving traffic over USB modem with bridge firewall enabled
- fixed CAP system upgrading process for MMIPS
- fixed interface-list usage in access list
- improved packet processing after overloading interface
- added "key-type" field
- added support for ECDSA certificates (prime256v1, secp384r1, secp521r1)
- fixed self signed CA certificate handling by SCEP client
- made RAM the default CRL storage location
- removed DSA (D) flag
- removed "set-ca-passphrase" parameter
- legacy adapters require "disable-running-check=yes" to be set
- added "replace" parameter for backup "upload-file" command
- fixed GRE protocol packet connection-state matching (CVE-2014-8160)
- significant stability and performance improvements
- fixed known multicast flooding to the CPU
- added ethernet tx-drop counter
- correctly display auto-negotiation information for SFP/SFP+ interfaces in 1Gbps rate
- fixed auto negotiation when 2-pair twisted cable is used (downshift feature)
- fixed "tx-drop" counter
- improved switch-chip resource allocation on CRS326, CRS328, CRS305
- added "custom-script" field that prints custom configuration installed by Netinstall
- automatically set "installation" parameter for outdoor devices
- changed default configuration type to AP for cAP series devices
- fixed channel width selection for RU locked devices
- create dual stack queue based on limitations specified on DHCPv4 server lease configuration
- do not require lease and binding to have the same configuration for dual-stack queues
- show warning in log if lease and binding dual-stack related parameters do not match and create separate queues
- added "client-mac-limit" parameter
- added IP conflict logging
- added RADIUS accounting support with queue based statistics
- added "vendor-class-id" matcher (CLI only)
- improved stability when performing "check-status" command
- replaced "busy" lease status with "conflict" and "declined"
- added option to disable rapid-commit
- fixed status update when leaving "bound" state
- added additional RADIUS parameters for Prefix delegation, "rate-limit" and "life-time"
- added "address-list" support for bindings
- added "insert-queue-before" and "parent-queue" parameters
- added RADIUS accounting support with queue based statistics
- added "route-distance" parameter
- fixed dynamic IPv6 binding without proper reference to the server
- override prefix pool and/or DNS server settings by values received from RADIUS
- correctly create neighbors from VLAN tagged discovery messages
- fixed CDP packets not including address on slave ports (introduced in v6.44)
- improved neighbour's MAC address detection
- limit max neighbour count per interface based on total RAM memory
- show neighbors on actual mesh ports
- include "message-id" identification field in e-mail header
- properly release e-mail sending session if the server's domain name can not be resolved
- added support for 25Gbps and 40Gbps rates
- fixed running (R) flag not present on x86 interfaces and CHR legacy adapters
- increased loop warning threshold to 5 packets per second
- added SFTP support
- improved user policy lookup
- fixed fragmented packet processing when only RAW firewall is configured
- process packets by firewall when accepted by RAW with disabled connection tracking
- fixed missing minus close to zero coordinates in dd format
- make sure "direction" parameter is upper case
- strip unnecessary trailing characters from "longtitude" and "latitude" values
- use "serial0" as default port on LtAP mini
- added "interface-mac" variable to HTML pages
- moved "title" HTML tag after "meta" tags
- adjusted debug packet logging topics
- added support for ECDSA certificate authentication (rfc4754)
- added support for IKE SA rekeying for initiator
- do not send "User-Name" attribute to RADIUS server if not provided
- improved certificate verification when multiple CA certificates received from responder
- improved child SA rekeying process
- improved XAuth identity conversion on upgrade
- prefer SAN instead of DN from certificate for ID payload
- improved logging for IPv6 Pool when prefix is already in use
- added dynamic comment field for "active-peers" menu inherited from identity
- added "ph2-total" counter to "active-peers" menu
- added support for RADIUS accounting for "eap-radius" and "pre-shared-key-xauth" authentication methods
- added traffic statistics to "active-peers" menu
- disallow setting "src-address" and "dst-address" for transport mode policies
- do not allow adding identity to a dynamic peer
- fixed policies becoming invalid after changing priority
- general improvements in policy handling
- properly drop already established tunnel when address change detected
- renamed "remote-peers" to "active-peers"
- renamed "rsa-signature" authentication method to "digital-signature"
- replaced policy SA address parameters with peer setting
- use tunnel name for dynamic IPsec peer name
- improved system stability when receiving bogus packets
- renamed SIM slots "up" and "down" to "2" and "3"
- added initial support for Vodafone R216-Z
- added passthrough interface subnet selection
- added support for manual operator selection
- allow setting empty APN
- allow to specify URL for firmware upgrade "firmware-file" parameter
- do not show error message for info commands that are not supported
- fixed session reactivation on R11e-LTE in UMTS mode
- improved firmware upgrade process
- improved "info" command query
- improved R11e-4G modem operation
- renamed firmware upgrade "path" command to "firmware-file" (CLI only)
- show alphanumeric value for operator info
- show correct firmware revision after firmware upgrade
- use default APN name "internet" when not provided
- use secondary DNS for DNS server configuration
- added support for additional Serial Console port on GPIO headers
- added support for link scope opaque LSAs (Type 9) for OSPFv2
- fixed opaque LSA type checking in OSPFv2
- improved "unknown" LSA handling in OSPFv3
- added "verify-server-certificate" parameter for OVPN client (CVE-2018-10066)
- added initial support for Quectel BG96
- increased minimal free RAM that can not be used for proxy services
- improved system stability when receiving bogus packets
- fixed MAC address duplication between sfp-sfpplus1 and wlan1 interfaces (wlan1 configuration reset required)
- improved system stability ("/system routerboard upgrade" required)
- renamed 'sim' menu to 'modem'
- fixed S-35LC20D transceiver DDMI readouts after reboot
- added USSD message functionality under "/tool sms" (CLI only)
- allow specifying multiple "allowed-number" values
- improved delivery report logging
- added "dot1dStpPortTable" OID
- added OID for neighbor "interface"
- added "write-access" column to community print
- allow setting interface "adminStatus"
- fixed "send-trap" not working when "trap-generators" does not contain "temp-exception"
- fixed "send-trap" with multiple "trap-targets"
- improved reliability on SNMP service packet validation
- properly return multicast and broadcast packet counters for IF-MIB OIDs
- accept remote forwarding requests with empty hostnames
- added new "ssh-exec" command for non-interactive command execution
- fixed non-interactive multiple command execution
- improved remote forwarding handling (introduced in v6.44.3)
- improved session rekeying process on exchanged data size threshold
- keep host keys when resetting configuration with "keep-users=yes"
- use correct user when "output-to-file" parameter is used
- improved stability when received traffic hits tarpit firewall
- added IPv6 ND section to supout file
- added "kid-control devices" section to supout file
- added "pwr-line" section to supout file
- changed IPv6 pool section to output detailed print
- properly reapply settings after switch chip reset
- added "max-block-size" parameter under TFTP "settings" menu (CLI only)
- improved link fault detection on SFP+ ports
- added LTE CQI and IMSI parameter support
- fixed potential memory corruption
- improved error reporting with incorrect firware upgrade XML file
- improved stability when sending large ping amounts
- improved stability when stopping traffic generator
- removed "local-address" requirement when "ipsec-secret" is used
- added support for "Delegated-IPv6-Pool" and "DNS-Server-IPv6-Address" (CLI only)
- do not show unused "dmg" paramete
- prefer AP with strongest signal when multiple APs with same SSID present
- show running frequency under "monitor" command
- added "System/SwOS" menu for all dual-boot devices
- do not allow setting "dns-lookup-interval" to "0"
- show "LCD" menu only on boards that have LCD screen
- fixed frequency duplication in the frequency selection menu
- fixed incorrect IP header for RADIUS accounting packet
- improved 160MHz channel width stability on rb4011
- improved DFS radar detection when using non-ETSI regulated country
- improved installation mode selection for wireless outdoor equipment
- set default SSID and supplicant-identity the same as router's identity
- updated "china" regulatory domain information
- updated "new zealand" regulatory domain information
- improved client-initiated renegotiation within the SSL and TLS protocols (CVE-2011-1473)
更新時間：2019-07-01
更新細節：
更新時間：2019-06-26
更新細節：
What's new in this version:
This release fixes the following issues:
- Fixes issues with loading metadata: Hierarchies in folders were causing an infinite loop
- Fixes issues with loading metadata:Certain combinations of folder names with and with out spaces were causing partial loading of metadata
- Fixes a warning message box is now displayed when attempting to open a file from the recent files list that has been deleted, renamed or moved.
Minor Enhancements:
- Folders are now sorted first by default in the metadata pane (you can switch back to the old pure alphabetical behaviour using an option in File -> Options)
- Added Visual Name to the header comment when copying query from PowerBI performance data to the query window
- Metadata loading performance has been improved by upto 6x
更新時間：2019-06-11
更新細節：
What's new in this version:
New item:
- Database diagrams Database diagrams were added back into SSMS. For details, see Database Diagrams.
- SSBDIAGNOSE.EXE The SQL Server Diagnose (command line tool) was added back into the SSMS package.
- Integration Services (SSIS) Support for scheduling SSIS package, located in SSIS Catalog in Azure or File System, in Azure. There are three entries for launching the New Schedule dialog, New Schedule… menu item shown when right-clicking the SSIS package in SSIS Catalog in Azure, Schedule SSIS Package in Azure menu item under Migrate to Azure menu item under Tools menu item and "Schedule SSIS in Azure" shown when right-clicking Jobs folder under SQL Server agent of Azure SQL Database Managed Instance.
Bug fixes:
- Accessibility Improved accessibility of the Agent Job UI.
- Accessibility Improved accessibility on Stretch Monitor page by adding accessible name for Auto Refresh button and also adding an intelligent Accessible Name that will help users know not only what button they are on but the impact of pressing it.
- ADS integration Fixed a possible crash in SSMS when trying to use the ADS registered servers.
- Database designer Added support for Latin1_General_100_BIN2_UTF8 collation (available in SQL Server 2019 CTP3.0)
- Data classification Prevent adding sensitivity labels to columns in history table, which isn't supported.
- Data classification Addressed issue related to incorrect handling of compatibility level (server vs database).
- Database designer Added support for Latin1_General_100_BIN2_UTF8 collation (available in SQL2019 CTP3.0).
- General SSMS Fixed an issue where scripting of pseudo columns in an index was incorrect.
- General SSMS Fixed an issue in Login properties page where clicking on the Add Credential button could throw a Null Reference Exception.
- General SSMS Fixed money column size display in index properties page.
- General SSMS Fixed an issue where SSMS wasn't honoring the Intellisense settings from Tools/Options in the SQL editor window.
- General SSMS Fixed an issue where SSMS wasn't honoring the Help settings (online vs offline).
- High DPI Fixed layout of controls in error dialogs for unsupported query options.
- High DPI Fixed layout of controls in New Availability Group page which on some localized version of SSMS.
- High DPI Fixed layout of New Job Schedule page. See the feedback forum for more details.
- Import flat file Fixed in issue where rows could be silently lost during the import.
- Intellisense/editor Reduced SMO-based query traffic to Azure SQL databases for intellisense.
- Intellisense/editor Fixed grammatical error in the tooltip displayed when typing T-SQL to create a user. Also, fixed the error message to disambiguate between users and logins.
- Log Viewer Fixed an issue were SSMS always opens the current server (or agent) log, even if double-clicking an older archive sign in the Object explorer. See the feedback forum for more details.
- SSMS setup Fixed the issue that was causing SSMS setup to fail when the setup log path contained spaces. See the feedback forum for more details.
- SSMS setup Fixed an issue where SSMS was exiting immediately after showing the splash screen.
- See these sites for more details: feedback forum, SSMS Refuses to Start, and Database Administrators.
- Object explorer Lifted restriction on enabling start PowerShell when connected to SQL on Linux.
- Object explorer Fixed an issue that was causing SSMS to crash when trying to expand the Polybase/Scale-out Group node (when connected to a compute node).
- Object explorer Fixed an issue where the Disabled menu item was still enabled, even after disabling a given Index. See the feedback forum for more details.
- Reports Correcting report to actually display GrantedQueryMemory in KB (SQL Performance Dashboard report). See the feedback forum for more details.
- Reports Improved the tracing of the log block in Always-On scenarios.
- ShowPlan Added new showplan element SpillOccurred to showplan schema.
- ShowPlan Added remote reads (ActualPageServerReads, ActualPageServerReadAheads ActualLobPageServerReads, ActualLobPageServerReadAheads) to showplan schema.
- SMO/scripting Avoid querying edge constraints during scripting for non-graph tables.
- SMO/scripting Removed constraint on sensitivity classification when scripting columns with Data classification.
- SMO/scripting Fixed in issue where "Generate Script" on a graph table fails when generating data. See the feedback forum for more details.
- SMO/scripting Fixed an issue where the EnumObjects() method wasn't fetching schema name for a Synonym.
- SMO/scripting Fixed an issue in UIConnectionInfo.LoadFromStream() where the AdvancedOptions section wasn't read (when a password wasn't specified).
- SQL Agent Fixed an issue that was causing SSMS to crash while working with a Job Properties window. See the feedback forum for more details.
- SQL Agent Fixed an issue where the "View" button on the Job-Step Properties wasn't always enabled, thus preventing viewing the output of a given job step.
- XEvent UI Added "Package" column to XEvents list to disambiguate events with identical names.
- XEvent UI Added missing "EXTERNAL LIBRARY" class type mapping to XEventUI.
更新時間：2019-06-10
更新細節：
What's new in this version:
Added support for 256-bit encryption:
- Styled checkboxes and radio buttons were sometimes rendered (and printed) incorrectly.
- Drop into form mode for a forms PDF.
- pasting text into invisible OCR text box causes a crash.
- Long tooltips could overflow the edge of the screen making them difficult to read.
- checkmarks in checkboxes were not always centred within their boxes in interactive forms
- Improved compatibility of interactive forms created in Infix with Adobe reader
- OCR Cancel button not working on Macintosh
- Tooltips of form objects were not being shown
- Pasting RTF from clipboard can cause a crash
- 'Join files' crashes.
- viewing overset text problems could cause a crash.
- Fixed font display issue which could result in gibberish text being displayed
Image missing on Activate dialog:
- Improved behaviour of auto-scrolling
- "Zoom in on results" increases zoom level too much
- Improve rendering of B/W bitmaps