I have Visual Studio .Net project which uses ADO connection to call stored procedure of SQL Server database.

It is possible to set a breakpoing at stored procedure and debug it. I have local SQL Server
and SQL Enterprise Edition installed.