THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Andrew Kelly

SSMS release 16.4 is now available


The newest release of SQL Server Management Studio (SSMS) is now available. The details and download link can be found here. If you haven’t already downloaded or tried the new SSMS I highly recommend getting it and giving it a whirl. With the new release cycles we will see new features and bug fixes on a regular basis. Enjoy.


Published Tuesday, September 20, 2016 4:53 PM by Andrew Kelly

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS



BarneyL said:

It's not an update I'd recommend at this point. The ability to generate alter scripts on objects is broken at present meaning you can't modify stored procedures, views etc.

September 21, 2016 9:39 AM

Andrew Kelly said:

Interesting. I just chose a procedure and right clicked and said Modify and got the error as well. But if you use the generate scripts option from the tasks menu it scripts without errors. It's a longer winded approach but can certainly get you buy until they fix this.

September 21, 2016 2:06 PM

Anonymous said:

I'm just curious how something like that breaks and the thing gets through testing and out the door... Seems indicative of a deeper issue with regard to the development process.

September 21, 2016 3:24 PM

Andy Mallon said:

If you script as CREATE, it works fine. Interesting that the "Modify" and "Script as Alter" options are both messed up, but CREATE works.

I actually *always* script as CREATE, and manually change to ALTER when I'm ready to run it. Because I've accidentally run the alter when my changes were half-baked and caused myself a problem. But I guess I'm a little unique there.

September 21, 2016 3:32 PM

Brandon Leach said:

Yeah.. Thats a no go for me. I'll wait until they fix it before updating.

September 21, 2016 4:57 PM

Shane O'Neill said:

It also works if you use sp_helptext. At least there's no more System.OutOfMemoryExceptions

September 22, 2016 4:40 AM

Dany Van den Steen said:

Microsoft pulled back this version

There is a known issue with the SSMS 16.4 release and we have rolled back the download to SSMS 16.3. We will update the download link when the issue has been resolved.


September 22, 2016 6:08 AM

Jon said:

It's been updated to 16.4.1, and the Modify/Script as alter bug is fixed.

@Adam - This new monthly release cadence clearly has some testing/QA challenges to overcome.  I'm enjoying the concept of a more frequent release cycle - but the execution is causing some grey hairs. :)

September 24, 2016 9:12 AM

andyleonard said:

For those looking: v16.4.1 is available at the link Dany provided (and I copied) above.

Developing and testing software is hard. Thanks for fixing this release so quickly, SQL Server Team!


September 24, 2016 2:35 PM

Chad Toney said:

Anybody else get this error when trying to install v16.4.1?

"Setup Failed

Incorrect Function: (0x80070001)"

September 24, 2016 9:26 PM

Gabriel Avila said:

Got the same error at install Incorrect function (0x80070001).

September 29, 2016 11:41 AM

look at this site said:

An fascinating discussion is value comment. I think that it is best to write extra on this matter, it won’t be a taboo topic however generally people are not enough to talk on such topics. To the next. Cheers

June 13, 2017 5:20 AM

wef said:    Chanel Outlet    payless shoes    80's Fashion    Nike Air Jordan Enfants    Michael Kors Outlet    Air Jordan Retro 3    ray ban shop    Promise Rings - Official    populaire Nike Lunarmax    puma outlet    coach factory outlet    katespade outlet    Nike Air Force    Coach Bags Outlet    NIKE Schuhe Shop    casio watches    michele watch    oakley australia    Air Jordan 10    qiqi fashion    birkenstock sandals    burberry bags outlet    michael kors shoes    Sunglasses outlet sale    Nike Air Jordan Enfants    ray ban clubmaster sunglasses    Cartier Watches    puma outlet online    hermes bag    louis vuitton outlet    coach factory outlet    clearance    prada outlet woodbury


February 10, 2018 7:28 PM

aaaa said:

April 1, 2018 5:22 PM

jhgf said:

April 8, 2018 11:13 PM

kuhhjk said:


<h1><a href="">شبیه">">شبیه سازی با متلب</a></h1>

<h2><a href="">انجام">">انجام پروژه متلب</a></h2>

<h2><a href="">انجام پروژه دانشجویی</a></h2>

[url=]شبیه سازی با متلب[/url]

<h2><a href="">پروژه متلب</a></h2>

<a href="">پروژه متلب</a>

پروژه متلب , انجام پروژه متلب , پروژه متلب

[url=]انجام پروژه متلب[/url] , [url=]پروژه متلب[/url], [url=]انجام پروژه دانشجویی[/url]

[url=]پروژه متلب[/url]

April 28, 2018 6:42 AM

chenyingying said:


May 6, 2018 10:41 PM

linying123 said:


May 10, 2018 8:05 PM

loemrntdherid1 said:

May 20, 2018 8:21 PM

shenyuhang said:


June 1, 2018 7:00 PM

dongdong8 said:



June 29, 2018 2:48 AM

hzx said:


July 11, 2018 11:56 PM

linying123 said:



July 16, 2018 8:31 PM

dongdong8 said:



July 23, 2018 11:29 PM

shenyuhang said:


July 23, 2018 11:37 PM

tuhrygtd said:

August 2, 2018 11:52 PM

yaoxuemei said:


August 15, 2018 2:09 AM

qqq said:

August 16, 2018 12:15 AM

chenjinyan said:



August 22, 2018 11:10 PM

shenyuhang said:


August 23, 2018 10:19 PM

Dissertation Writing Service said:

August 29, 2018 5:06 AM

chenlixiang said:



September 18, 2018 10:00 PM

kakakaoo said:

October 8, 2018 2:19 AM

chenjinyan said:



October 9, 2018 6:49 PM

chenqiuying said:


October 10, 2018 6:28 PM

matlab said:

Such a great teacher and responsibility. Thanks!

Valuable information! Looking forward to seeing your notes posted. The information you have posted is very useful. Keep going on, good stuff. Thank you for this valuable information.

<a href="">انجام پروژه های متلب</a>

<a href="">انجام پروژه متلب</a>

<a href="">انجام پروژه </a>

October 14, 2018 10:16 AM

shahzaib said:

October 29, 2018 12:37 AM

kakakaoo said:


November 8, 2018 2:03 AM

fghgfh said:

December 13, 2018 10:36 PM

rusli said:

tes saja lah

htlm code

<a href="">undangan">">undangan pernikahan</a>

<a href="">undangan">">undangan pernikahan unik</a>

<a href="">undangan">">undangan pernikahan unik</a>

ini cuma pake ling

bb code

[url=]undangan pernikahan[/url]

[url=]undangan pernikahan simple[/url]

[url=]undangan pernikahan unik[/url]


January 10, 2019 11:59 PM

Leave a Comment


This Blog


Privacy Statement