SQL Management studio 'script' feature bugged while in "take database offline" window - by CasiNN

Status : 

  Fixed<br /><br />
		This item has been fixed in the current or upcoming version of this product.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.


1
0
Sign in
to vote
ID 3132348 Comments
Status Resolved Workarounds
Type Bug Repros 0
Opened 4/12/2017 9:13:23 AM
Access Restriction Public

Description

SQL Management studio 'script' feature is great for people trying to learn T-SQL and wanting to know what's happening underneath a GUI. As far my understanding goes this feature should not execute any command automatically (just create T-SQL code for us, that we can review or use later on). 

There is one exception to that. IF after we open database context menu and choose Take offline task, and we decide to click 'Script' - the database will just go offline without any warnings. Even if we cancel this menu database will stay offline.

I think it's a bug because script feature should never work this way. 
Sign in to post a comment.
Posted by Microsoft on 4/21/2017 at 12:00 PM
This has been fixed in the latest version of SSMS - please update to that and let us know if you still encounter the error.

https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms

-Charles Gagnon (chgagnon@microsoft.com)