SQL Debugging: Error when Debugging Procedures with Names that Contain Quotes
This topic applies to:
Edition |
Visual Basic |
C# |
C++ |
Web Developer |
|---|---|---|---|---|
Express |
.gif "Topic does not apply") |
|
|
|
Standard |
|
|
|
|
Pro and Team |
.gif "Topic applies") |
|
|
|
Table legend:
|
Applies |
|
Does not apply |
.gif "Topic applies but command hidden by default") |
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