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

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 7,2000 » Administration » How to track the Errors which occurs while a...

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

Rate Topic

Display Mode

Topic Options

Author

Message

dakshinamurthy-655138

Posted Saturday, June 28, 2008 4:00 AM

Old Hand

Group: General Forum Members
Last Login: Friday, June 14, 2013 8:27 AM
Points: 329, Visits: 890

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 »

Permissions