Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Important This document may not represent best practices for current development, links to downloads and other resources may no longer be valid. Current recommended version can be found here.

SQL Debugging: Error when Debugging Procedures with Names that Contain Quotes

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.

Community Additions

ADD
Show:
© 2015 Microsoft