Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-02-05 : 07:09:59
|
| Ben writes "Hello, When I run a stored proc using QA which call another stored proc and an error occurs i get a message like thisServer: Msg 208, Level 16, State 1, Procedure xyx, Line 7Invalid object name '#temp_tbl'. However I can't seem to get this kind of rich error info thro ADO's errors collection.I want to access the proc name and line number through ADO when the error occurs. I basically have stored procs that are nested several levels deep.eg sp_1 call sp_2 calls sp_3.. however ADO tells me only that sp_1 has failed when infact sp_3 has failed... if i could get the line number too that would be great. I read in BOL that this is possible using ISQLServerErrorInfo OLEDB interface.. since ADO wraps OLEDB can I get direct access to this interface.. I am not in a position to convert my whole code to raw OLEDB just for this thing obviously.." |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2004-02-05 : 12:15:49
|
| ummmm testing in QA?Several levels deep?Why?I mean code reuse is a good thing...but for some reason I get a sense that that's not what's going on here....Brett8-) |
 |
|
|
|
|
|
Get the line number and exact stored proc in ADO for errors