Learn how to troubleshoot and resolve permission issues in your T-SQL stored procedures using EXECUTE AS, SQL Server Profiler, sys.fn_my_permissions, sp_helprotect, and TRY/CATCH blocks.

A more preventive way to debug T-SQL stored procedures is to use SQL Prompt, a tool that enhances the coding experience and productivity in SQL Server Management Studio or Visual Studio.

Visual Studio Professional and Team System editions allow you to set breakpoints and step in to stored procedures within SQL Server, making debugging stored procedures as easy as debugging application ...