Share via


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

This topic applies to:

Visual Studio Ultimate

Visual Studio Premium

Visual Studio Professional

Visual Studio Express

abk849z6.DoesApplybmp(en-us,VS.100).gif abk849z6.DoesApplybmp(en-us,VS.100).gif abk849z6.DoesApplybmp(en-us,VS.100).gif abk849z6.DoesNotApplybmp(en-us,VS.100).gif

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

Transact-SQL Debugging Setup Errors and Troubleshooting

Other Resources

Setting Up Transact-SQL Debugging