Export (0) Print
Expand All
0 out of 2 rated this helpful - Rate this topic

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.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.