Our Training Programs

All contents are copyright of their authors.

How to debug procedure in SQL Server 2000

How to debug procedure in SQL Server 2000

anand m

5yAsked Oct 11, 2020, 10:15 AM781

Hello All,

Please help me to trouble shoot the procedure there in my SQL Job.

1. In SQL Job I am pointing to the windows batch file(.bat)

2. In that bat file having procedure are running

3. Once Job run it pick data to insert from flat file(.txt) pointing to running procedure.

4. In this how i need to debug trace error log while debugging procedure.

How to trace out the error while bugging sql server 2000 procedures.

Thanks

Anand

Know the answer? Post it — somebody with the same question will find it here.

It is the same account you read, post and publish with — and you will come straight back to this page.

anand m5y ago
Hello Mageshwaran,

I am using SQL Server 2000 legacy version, which ever you posted on the higher version.
Help me how to debug on this version while runing the SQL job.

Thanks
Anand
Mageshwaran R5y ago
Hi Anand,
please refer this link:
https://stackoverflow.com/questions/2016879/debugging-stored-procedures-in-sql-server-management-studio
Bhavna Chaudhri5y ago
1. DECLARE
2. @ErrorMessage varchar(2000)
3. ,@ErrorSeverity tinyint
4. ,@ErrorState tinyint
6. /* Additional code */
8. BEGIN TRY
10. /* Your code here */
12. END TRY
14. BEGIN CATCH
15. SET @ErrorMessage = ERROR_MESSAGE()
16. SET @ErrorSeverity = ERROR_SEVERITY()
17. SET @ErrorState = ERROR_STATE()
18. RAISERROR(@ErrorMessage, @ErrorSeverity, @ErrorState)
20. BREAK
21. END CATCH