Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

How to track the Errors which occurs while a store procedure is executed in SQL Server 2000 Expand / Collapse
Author
Message
Posted Saturday, June 28, 2008 4:00 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, October 14, 2014 8:44 AM
Points: 330, Visits: 974
Hi,

How to track the Errors which occurs while a store procedure is executed in SQL Server 2000

My Query is , i need to identify the store procedures which has fired error while the sp is executed through the application or manually if we execute the store procedure

and also i need to know
how to trace the Errors automatically which occurred while a stored procedure is executed without
using try catch + SQL Server 2005

Please let me know.

with Regards
Dakshina
Post #525462
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse