Unable to generate script for Numbered Stored Procedures with quoted_identifier on and double quotes in object names - by André César Rodrigues

Status : 


Sign in
to vote
ID 1081560 Comments
Status Active Workarounds
Type Bug Repros 0
Opened 1/9/2015 4:16:30 AM
Access Restriction Public


When I tried to generate the script through the wizard of a Numbered Stored Procedure with double quotes in his name I got the error below:

Microsoft.SqlServer.Management.Smo.FailedOperationException: Syntax error in TextHeader of NumberedStoredProcedure.

The "CREATE TO" and "DROP AND CREATE TO" fails with the same error. 

The DROP works fine.

The ALTER works but only shows the first procedure of the chain, is that ok? 
Sign in to post a comment.
Posted by Microsoft on 1/22/2015 at 4:43 PM
Thank you for submitting this feedback. We are investigating the issue and will update you when we have more information.
Matt Jones
SQL Server Tiger Team