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 ...

At last month's VSLive! 2002 in Orlando, Fla., Compuware announced the availability of an update to its workbench for debugging stored procedures on SQL Server. New features include stored-procedure ...

I recently wrote a .NET web application for work. I always make a data access class with methods for getting data, but I usually just point the methods to stored procedures. This time, I decided ...