Sql Server Programming :: How to debug sp or function in SQL 2005


	How to debug sp or function in SQL 2005 Hi, all, I could not find how to debug the stored procedure or functions in SQL Server 2005, I downloaded a tooling application which could debug the sp but there are still some limitations. Could anyone kindly please tell me how to debug them? Thanks, Jack Embarcadero currently. ApexSQL Edit soon. -- TheSQLGuru President Indicium Resources, Inc. "Jack Zhong" <cnlohm@yeah.net> wrote in message news:eKQ856GqHHA.3736@TK2MSFTNGP03.phx.gbl... Hi, all, I could not find how to debug the stored procedure or functions in SQL Server 2005, I downloaded a tooling application which could debug the sp but there are still some limitations. Could anyone kindly please tell me how to debug them? Thanks, Jack -----------------------------------------------Reply----------------------------------------------- Yes, I just used the Embarcadero's application, but it seemed could not debug function, I created a sp to execute the function and debug with the ER application, it failed and threw out some exceptions. "TheSQLGuru" <kgbo@earthlink.net> :%23LBOK$GqHHA.3@TK2MSFTNGP05.phx.gbl... Embarcadero currently. ApexSQL Edit soon.