Home     |     .Net Programming    |     cSharp Home    |     Sql Server Home    |     Javascript / Client Side Development     |     Ajax Programming

Ruby on Rails Development     |     Perl Programming     |     C Programming Language     |     C++ Programming     |     IT Jobs

Python Programming Language     |     Laptop Suggestions?    |     TCL Scripting     |     Fortran Programming     |     Scheme Programming Language


 
 
Cervo Technologies
The Right Source to Outsource

MS Dynamics CRM 3.0

Sql Server Programming

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.

Add to del.icio.us | Digg this | Stumble it | Powered by Megasolutions Inc