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 |
|
dasu
Posting Yak Master
104 Posts |
 Posted - 2004-08-18 : 02:29:26
|
| hello,thank u for ur assitence for previos querriesthen iam coming up with another querry please help me to solve this.how to capture the only message from @@error not int value |
|
|
timmy
Master Smack Fu Yak Hacker
1242 Posts |
Posted - 2004-08-18 : 02:42:51
|
| You can get the error message via ADO if that's what you're using. All you need to do is iterate through the ADO Error collection. It will also return all the 'print ...' statements that might be in your procedure. |
 |
|
|
dasu
Posting Yak Master
104 Posts |
Posted - 2004-08-18 : 03:29:56
|
| iam donot ado but just i want capture this info in a stored procedure and i want to send this info to another storedprocedure |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2004-08-18 : 04:36:14
|
| there is a table sysmessages where the errors are saved. so you can get it from there.use masterselect * from sysmessagesGo with the flow & have fun! Else fight the flow :) |
|
|
|
|
|
|
how to capture msg from @@error