alter or create view scripts missing GO statement - by RakAttack

Status : 

  Not Reproducible<br /><br />
		The product team could not reproduce this item with the description and steps provided.<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 776541 Comments
Status Closed Workarounds
Type Bug Repros 0
Opened 1/14/2013 4:02:16 PM
Access Restriction Public

Description

When I right-click a view and either select alter view or create view, the generated script is missing GO commands so when I try and run it I get errors.
Sign in to post a comment.
Posted by Microsoft on 3/20/2013 at 11:26 AM
Hello We didn't recieve any update from you on this issue, so we assume that the issue was resolved and we will go ahead and close it. You can always reactivate it later and provide more details as needed. Thank you Alex Grach[MSFT]
Posted by Microsoft on 1/21/2013 at 11:49 AM
Hi RakAttack,
Looks like you have set the scripting option "Delimit individual statements" to false. To set it to true, from SSMS menu, select "Tools" -> "Options". In the left of the "Options" window, select "SQL Server Object Exploer" -> "Scripting". Expand "General scripting options" and set "Delimit individual statements" to true.
Please try to script any views again and Let us know if you have any questions.

Thanks

Jinlin Zhang
Microsoft Sql Server
Posted by Microsoft on 1/15/2013 at 11:15 AM
Thank you for reporting this issue - we are investigating and will update you when we have more information.

Thanks,

Alex Grach [MSFT SQL SERVER]