Click to Rate and Give Feedback
MSDN
MSDN Library
Visual Studio .NET
Debugging
Debugging SQL
 SQL Debugging: Error when Debugging...
This page is specific to
Microsoft Visual Studio 2003/.NET Framework 1.1

Other versions are also available for the following:
Visual Studio
SQL Debugging: Error when Debugging Procedures with Names that Contain Quotes

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

Setting Up SQL Debugging | Troubleshooting SQL Debugging Setup | Debug Settings and Preparation

© 2009 Microsoft Corporation. All rights reserved. Terms of Use | Trademarks | Privacy Statement | Site Feedback
Page view tracker