By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
444,077 Members | 1,790 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 444,077 IT Pros & Developers. It's quick & easy.

Identifying Error Line in a Stored Proc

P: 1
Hi

We record the error line using the Err_Line() function within the catch block for our procedures.

When we open the procedure and check the corresponding line number using a Management Studio Console, the line numbers do not see to match. We sometimes are shown a blank/empty line !!

How is this normally done to identify the exact line of code where the error occured?

Regards
Ramesh
Mar 24 '08 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.