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.