SQL Debugging: Error when Debugging Procedures with Names that Contain Quotes
Visual Studio 2005
This topic applies to:
| Visual Studio Edition | Visual Basic | C# | C++ | J# | Visual Web Developer |
| Express | No | No | No | No | No |
| Standard | No | No | No | No | No |
| Pro/Team | Yes | Yes | Yes | Yes | Yes |
If the name of a stored procedure contains quotation marks, you may get a debugger error message like the following:
SQL Debugging: Error while executing 'A Batch Cmd' at line 0;
SQL Error: 2812 Stored procedure 'dbo.AuthorProc' not found.
To avoid this problem, add the line SET QUOTED_IDENTIFIER ON to the procedure.
