SQL Debugging: Error when Debugging Procedures with Names that Contain Quotes
This topic applies to:
Edition |
Visual Basic |
C# |
C++ |
Web Developer |
---|---|---|---|---|
Express |
![]() |
![]() |
![]() |
![]() |
Standard |
![]() |
![]() |
![]() |
![]() |
Pro and Team |
![]() |
![]() |
![]() |
![]() |
Table legend:
![]() |
Applies |
![]() |
Does not apply |
![]() |
Command or commands hidden by default. |
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.
See Also
Reference
SQL Debugging Setup Errors and Troubleshooting