November 11, 2003 at 10:38 am
Hi, how do I trap the line number causing the error number from within a stored procedure? I can see that I can do this via english query or odbc but not straigh tsql.
Any clues?
November 11, 2003 at 3:17 pm
don't think there is a way.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
November 11, 2003 at 8:05 pm
Then, what will be the error description you are getting on the front end application ??
Linto
November 12, 2003 at 2:13 am
Since you can write your t-sql code in one line or each word in a new line and the used approach may vary from developer to developer in your organization, the results will no real meaning, if there is a way at all.
Nigel Rivett has posted this some days ago, which might show you another approach http://www.nigelrivett.net/spFormatOutputBuffer.html
Frank
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply