Announcing SQL Server Management Studio – June 2015 Release
With the release of SQL Server 2016 Community Technology Preview (CTP) 2.1, customers can for the first time experience the rapid preview model for their on-premises SQL Server 2016 development and test environments and can gain a faster time to production.
In addition, we are delighted to announce our first "preview" release of SQL Server Management Studio! This is our first effort to release SQL Server Management Studio (SSMS) in a mechanism outside of the SQL Engine releases. Our goal is to update this frequently with new features, fixes and support for the newest SQL Server features in SQL Server Engine and Azure SQL Database.
We invite you to download and install SQL Server Management Studio June 2015 Preview from here
This preview release supports the latest capabilities available in Azure SQL Database and SQL Server 2016 and includes several bug fixes and customer requested features. And as you would expect, you can also use this preview release to work with previous versions of SQL Server.
New Features
- New lightweight Web Installer
We hope that the new SSMS installer is lightweight, fast and better experience for you to get SSMS tools. In particular, if you have already installed certain dependencies (say, .net framework), then the installer will not have to download them. In particular, as we release frequent updates to the tools, the installer should just update the components that have changed.
- Automatic Check for Updates
SSMS will now check online for updates. If an update is available, you will be notified via a toast notification in SSMS. Alternatively, you can manually click on "Tools|Check For Updates..." to see if there are updates available.
- Top customer requests addressed
‘Edit Top 200 Rows’ is now enabled for tables and views in Object Explorer
Table Designer is now enabled for Azure SQL Database V12
Database and Table property dialogs are now enabled for Azure SQL Database V12
- New option to skip prompt to save T-SQL files
We have added a new option under "Tools|Options|Query Execution|SQL Server" to control if a prompt is shown for unsaved T-SQL files.
Updated Import/Export wizards with support for the new Azure SQL Database service tiers (Basic, Standard, Premium)
Bug fixes to provide enhanced support for Azure SQL Database
Numerous bug fixes for scripting scenarios
Fixed bug when enabling change tracking for Azure SQL Database V12
We would be delighted to hear from you. Please ask us questions and submit your feedback on the SQL Client Tools Forum and on Microsoft Connect
Comments
Anonymous
June 23, 2015
It seems the actual link for 'blog post link here' is missing? I also get a 'We're sorry, the page you requested cannot be found.' for the download link. Will this work side-by-side (without problems) with existing products? (SSMS2012/VS2012/etc)? Or do we need to be aware of not installing this on a 'production' machine?Anonymous
June 23, 2015
I will piggy back Jeroen Janssen concerns: Will this work side by side? Links seem to be broken! in addition, will this self update to RTM or will it need to be uninstalled later for RTM?Anonymous
June 23, 2015
How about updating to a newer Shell than VS 2010?Anonymous
June 24, 2015
Hi Jeroen, thank you for your prompt feedback. The links have been fixed. Please let us know if you are still seeing this problem. Yes, the SSMS June 2015 preview can be installed side-by-side with SSMS from previous versions of SQL Server and Visual Studio. Since this is preview software, we recommend you install this software on non-production computers.Anonymous
June 24, 2015
Hi SQL Padre, to your question on whether this will self-update to RTM, the answer is no. The SSMS June preview will not self-update to later releases. Instead, SSMS will automatically check for updates and notify you when there are updates available and you can then choose if/when to install the updates.Anonymous
June 24, 2015
Hi Erik, Yes, updating SSMS to the latest Visual Studio 2015 shell is part of our roadmap. We don’t have an exact date to share at this time though.Anonymous
June 24, 2015
It would be nice if SSMS would address more feature requests that aren't related to Azure.Anonymous
June 24, 2015
+1 ErikEJ and m60freeman An actual supported plugin architecture would be good, and better version control support would be nice. Tools like 0xDBE from JetBrains have SSMS beat by a mile in that regard, and they support multiple RDBMS to boot (not to mention re-factoring, intelligent code completion, etc). Also - big tip, if you're going to ask people to send questions and feedback to MSDN or Connect, then it'd be a good idea to actually respond to it and/or use those tools to actually support your customers. I don't waste my time with MSDN forums any more because it's just outsourced help desk type support pushing people to post issues on Connect. And Connect is worth even less mention - because quite frankly I get better support from volunteers working OS projects on github than I do the products I've paid dearly for on Connect.Anonymous
June 24, 2015
Thank you Kevin for your feedback. We are looking into the plug-in model for SSMS but as we are still in early stages of evaluating we do not have anything specific to share at this time. SSMS currently offers support for TFS version control with the MSSCCI plug-in and we are looking to support additional version control systems (including Git) as part of our roadmap to update SSMS to the Visual Studio 2015 shell. The product team is closely monitoring your feedback on connect and on the SQL Client Tools forum. Please do share your feedback and we, the product team, will respond.Anonymous
June 24, 2015
Can I throw in a random feature request here? Due to the fact that transactions are automatically committed by default, how about showing a prompt when an update/delete query is run that doesn't have a "where" clause? The lack of prompt hasn't bitten me yet, but I have a friend that almost lost their job over it.Anonymous
June 24, 2015
I was hoping this version would finally fix the problem that float and decimal have different decimal separators, but unfortunately no. Decimals still don't use the one assigned in regional settings.Anonymous
June 24, 2015
Unfortunately the installer failed for me with message "Element not found". The log file has a number of errors around certificates - e.g. "Failed to find expected public key in certificate chain", "Failed to verify signature of payload: ReportViewer.msi", etc.Anonymous
June 24, 2015
Looks good but please use the latest version of visual studio shell, this looks pretty dated :)Anonymous
June 25, 2015
Looks like something in Check for Updates doesn't understand SemVer see this twitter.com/.../614087305876254720Anonymous
June 25, 2015
I hope to see "Save As" - *.xlsx onceAnonymous
June 25, 2015
I was trying to install on the machine having SQL 2016 CTP2, and I got this error when I try to install: "A database engine with version 13.0.0200.172 was found which is incompatible with this application being installed. Please uninstall the current database engine or upgrade it to version 13.0.300.44 and rerun this setup"Anonymous
June 25, 2015
I'm getting the same "Element Not Found" error as Chris Anderson, around certificate chain for the Report Viewer. It's a shame, I really like the idea of an out of band release for SSMS. One change I'd really like to see is the Taskbar jumplist feature connections rather than files - you don't save files you want to go back to nearly as often as you'd have several connections to servers, that you could connect and open to easier and quicker from the jumplist.Anonymous
June 25, 2015
Hello All, If you are seeing Package load errors in Visual Studio 2015 RC after installing SQL Server Management Studio June 2015 preview release, please refer to the following post on SQL Server Tools forum for the workaround: social.msdn.microsoft.com/.../package-load-errors-in-visual-studio-2015-rc-after-installing-sql-server-management-studio-june-2015 Regards, RajeshAnonymous
June 26, 2015
Hi Mike H, Thank you for bringing this to our attention. Can you please file a Connect bug (link available at the end of this blog post) for this issue so we can keep track of it and triage it together with other feature requests?Anonymous
June 26, 2015
Hi Toni S, Thank you for your feedback. We are aware of this issue and there is an active Connect bug tracking it. We will triage and look into it, although we don’t have a timeline for a fix at this point.Anonymous
June 26, 2015
Thanks aL, yes, updating SSMS to the new VS shell is on our agenda.Anonymous
June 26, 2015
Hi Marc, Yes, we are aware of this issue and actively looking into it. Once we have a fix available we will include it in the next SSMS release.Anonymous
June 26, 2015
Hi Yevhen, As an alternative, you can save the result row sets as csv.Anonymous
June 26, 2015
The comment has been removedAnonymous
June 29, 2015
To work around the issue “No element found” that Chris Anderson and Andrew Tobin have encountered, move the SSMS-Web-Setup.exe file to an empty folder. You probably have an old ReportViewer.msi in your ~/Downloads/ folder which, due to how SSMS-Web-Setup.exe implements offline installation support, is preventing the installer from trying to download the version it wants to install.Anonymous
June 29, 2015
The option to disable the File Save prompt doesn’t work for me: http://imgur.com/a/1qRVEAnonymous
June 29, 2015
The comment has been removedAnonymous
June 30, 2015
@ohnobinki Thanks for reporting this issue. We have created a bug on our side to track this issue as I'm assuming that you are trying to close SSMS program itself or rebooting your machine and running into this issue. This options currently eliminates prompting when from closing individual T-SQL query windows in SSMS. Regards, RajeshAnonymous
July 01, 2015
The comment has been removedAnonymous
July 01, 2015
@Jake I didn't got your comment completely. If you could clarify more that will help me understand your issue completely. You said that you were unsuccessful in installing SSMS from SQL 2016 CTP2. So have you tried removing it completely or do you have a partial install of that currently on your machine? SSMS version for SQL 2016 CTP2 is 13.0.200.172. If you have successfully installed SSMS June 2015 preview, it should have upgraded your SSMS to 13.0.300.44. You can verify by looking at "Microsoft SQL Server Management Studio" Version in Add/Remove Programs. What makes you believe that you SSMS has not been upgraded to this new preview version? You can go to Help->About menu option in SSMS which should show you the version that's installed. Regards, RajeshAnonymous
July 01, 2015
I tried to install, but failed with following error (fragment from log file): [2015-07-02T11:21:10]e000: Error 0x800700a1: Failed to send request to URL: go.microsoft.com/fwlink [2015-07-02T11:21:10]e000: Error 0x800700a1: Failed to connect to URL: go.microsoft.com/fwlink [2015-07-02T11:21:10]e000: Error 0x800700a1: Failed to get size and time for URL: go.microsoft.com/fwlink [2015-07-02T11:21:10]e000: Error 0x800700a1: Failed attempt to download URL: 'go.microsoft.com/fwlink to: '(this path fragment was deleted by me)AppDataLocalTemp{f269d69c-de56-4f4a-a30d-ab18854a60e7}sql_tools.msi' If you need more information from log file, please leave comment.Anonymous
July 01, 2015
I managed to install SSMS June 2015 Preview. I don't know if it has anything to do with the URLs that Installer found problematic and put information in log file (posted in previous comment), but this time I copied the installer file to some folder on drive C (previously on Desktop) and hit "Options" in installer to change location to the same folder and now it worked.Anonymous
July 01, 2015
The comment has been removedAnonymous
July 02, 2015
My biggest desire for SSMS 2016 would be the ability to show query scripts in the solution explorer alphabeticallyAnonymous
July 02, 2015
@Jake Jake, would you mind opening a Connect bug for the same, so that I can request more information from you easily via email and then we can come back here and post the solution if needed? Here is the link to create a Connect bug: connect.microsoft.com/.../Feedback Here are some comments on your last post: Running sql_ssms.msi is not the supported/right way to install SSMS as that's not a redist msi. In order to install SSMS you need to go via SQL setup(by running setup.exe) and choosing Management Tools - Basic and Complete as the Features. As you mentioned that you have Windows 7, you would not be able to run the SQL 2016 CTP2 installer. So looks like you have got the SQL 2016 CTP2 bits on your machine through one or more of unsupported ways. Do you see "Microsoft SQL Server 2016 CTP2.0(64-bit)" entry in your Add/Remove Programs? If yes, please right click on it and select "Uninstall". That should uninstall anything you might have installed from CTP2. If not, I may need to refer to our setup experts to try to get you out of this state. Having a Connect bug for the same would help in that case. SSMS June 2015 preview release is supported on Windows 7 SP1 and above, so you should be able to install this on a clean machine. Did the SSMS-Web-Setup.exe ran successfully on your machine without any errors? You somehow still has the SSMS from SQL 2016 CTP2 installed based on your comments. Please open a Connect bug and provide all this info there and we can proceed from there. Regards, RajeshAnonymous
July 02, 2015
Just posted a connect item on this preview. In a nutshell, I get an error trying to edit a job step in an SQL Server agent job. connect.microsoft.com/.../ssms-preview-errorAnonymous
July 03, 2015
Can you think the world without SQL and Databases? :P <a href="http://www.copalibertadores2015.net">Sammy</a>Anonymous
July 07, 2015
Time to start open sourcing key parts, and also allow the community to write extensions. There is a host of functionality that could be added by the open source community! Unfortunately, it seems like over the last few versions the goal of management studio is to meet M$ model which is to move everyone to azure to get the recurring revenue from the cloud. Hopefully the more frequent updates do more than just include new azure features.Anonymous
July 21, 2015
Is SSMS for 2016 going to have a 64-bit version?Anonymous
July 21, 2015
@Chris: The SSMS web installer works on both 32-bit and 64-bit machines by pulling in required bits as necessary. Have you had any issues with the installer?Anonymous
July 23, 2015
Installer doesnt work [1B24:0D10][2015-07-23T10:56:35]i000: Registry key not found. Key = 'SOFTWAREMicrosoftMicrosoft SQL ServerRefCountsql_engine_core_shared13' [1B24:0D10][2015-07-23T10:56:35]i000: Registry key not found. Key = 'SOFTWAREMicrosoftUpdatesMicrosoft Visual Studio 2010 Shell (Isolated) - ENUSP1KB983509' [1B24:0D10][2015-07-23T10:56:35]i000: Registry key not found. Key = 'SOFTWAREMicrosoftMicrosoft SQL Server130ToolsClientSetupCurrentVersion' [1B24:0D10][2015-07-23T10:56:35]i000: Registry key not found. Key = 'SOFTWAREMicrosoftMicrosoft SQL Server130ToolsClientSetupCurrentVersion' [1B24:0D10][2015-07-23T10:56:35]i000: Registry key not found. Key = 'SOFTWAREMicrosoftWindowsCurrentVersionComponent Based ServicingPackagesPackage_for_KB2919355~31bf3856ad364e35~amd646.3.1.14' [1B24:0D10][2015-07-23T10:56:35]i000: Registry key not found. Key = 'SOFTWAREMicrosoftWindowsCurrentVersionComponent Based ServicingPackagesPackage_for_KB2919355~31bf3856ad364e35~x866.3.1.14' [1B24:0D10][2015-07-23T10:56:35]i000: Registry key not found. Key = 'SOFTWAREMicrosoftMicrosoft SQL ServerRefCountsql_engine_core_shared13' [1B24:0D10][2015-07-23T10:56:35]i052: Condition '(VersionNT <> v6.3) OR (KB2919355_amd64_CurrentState = 112 OR KB2919355_x86_CurrentState = 112)' evaluates to false. [1B24:0D10][2015-07-23T10:56:35]e000: Error 0x81f40001: Bundle condition evaluated to false: (VersionNT <> v6.3) OR (KB2919355_amd64_CurrentState = 112 OR KB2919355_x86_CurrentState = 112) [1B24:0D10][2015-07-23T10:56:35]i199: Detect complete, result: 0x0Anonymous
July 23, 2015
SSMS IDE is ALWAYS at least one generation back than current Visual Studio IDE. Is that a bad joke?Anonymous
August 06, 2015
This took longer to install than downloading the enterprise ISO and installing a default instance with SSMS as an installed feature combined.Anonymous
August 11, 2015
Are there plans to bring the designer up to date? For instance it can't cope with anything as simple as a union statement - it's very frustrating!Anonymous
August 14, 2015
Where do we make requests for features? My biggest ask is History. Instead of saving every query as a file which can run into the hundreds per day. It would be nice if it saved a little XML(JSON) file with all of my executed code. Second ask... Tabbed result sets. Would like to be able to see tabbed results... If I run a query in a tab it should create a Result tab. If I run it again make Result tab 2. Third Ask - Intellisense#!&#. If I try to write "select To from " ... it turns the to into Topic... id turns into Identity and i have to back space a bunch. option to turn intellisense into a drop down that lets me pick from a list or if I hit tab choose the highlighted one. Fourth Ask - Generate Script - make it so I can do all that goodness from the Generate Scripts right on the object itself. So instead of having to wade through all of that for just generating 1 script i can right click on an object Generate Scripts... boom done. Thanks!Anonymous
August 14, 2015
@Jay Tyler Would you mind filing a connect bug here: connect.microsoft.com/.../Feedback We review all of them and it would be helpful if you could let us know the problems you're facing using the current designerAnonymous
August 14, 2015
@Gwired
- You can make requests for features at the SQL Server connect page. Don't hesitate to file one for every one of your asks. We are actively looking through these bugs for features to add to SSMS: connect.microsoft.com/.../Feedback
- Could you give a bit more detail about your ask for History? This seems like an interesting scenario and I'd like to make sure we understand the problem you're trying to solve.
- 'Script <object type> as' works at an object level right now. More details here: msdn.microsoft.com/.../hh245282.aspx
Anonymous
September 26, 2015
Need 64-bit ssms -- 32-bit CANNOT export to 64-bit office files.Anonymous
October 09, 2015
Does this version of SSMS finally do real auto-recovery, even of unsaved queries?Anonymous
October 29, 2015
As usual you guys forget to include a link for ISO image. My development environment is not connected to Internet! You know, because Microsoft cannot guaranty security of my system!Anonymous
October 30, 2015
@Bob: Hi Bob. To copy SSMS to a machine that is not online, you can run the following command: "SSMS-Web-Setup.exe –layout <Directory Name>". This will download all necessary packages to the specified directory and you can copy these contents to the desired machine. More info is available in our release notes available here: msdn.microsoft.com/.../mt238486.aspxAnonymous
November 11, 2015
@64ssms: Can you describe your workflow/scenario a bit more? I'm interested in the error you're seeing.Anonymous
November 23, 2015
Where can we submit feature requests for SSMS 2016?Anonymous
November 23, 2015
@Dirk: You can submit feature requests at our connect page here: connect.microsoft.com/.../FeedbackAnonymous
April 10, 2016
Saya akan segera ambil Anda rss pakan karena saya tidak bisa Anda email berlangganan hyperlink atau buletin layanan. Apakah Anda memiliki Anda sudah salah? Harap memungkinkan me mengakui sehingga Aku mungkin berlangganan. Terima kasih.Anonymous
June 09, 2016
Hi, I searched but I could not find the full offline installation for SSMS 2016. I don't want the web installer because there are servers that do not have access to the Internet. Does anyone have the link to download the full offline installation files? Thanks in advance.