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 |
|
mnttr
Starting Member
9 Posts |
 Posted - 2002-09-09 : 07:44:18
|
| I'v got the errorcode 207,and i get the errormessage from sysmessagesis: Invalid column name '%.*ls'.how can i get and return the messages and '%.*ls' replaces with the real objects in my procedure? |
|
|
jasper_smith
SQL Server MVP & SQLTeam MVY
846 Posts |
Posted - 2002-09-09 : 08:06:34
|
| You can't do this server side, the error returned to the front end (if there is one) will have the placeholders replaced with the correct values.HTHJasper Smith |
 |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2002-09-09 : 08:15:03
|
| The replaced variables are not stored anywhere.The full message is accessible in the output bufferseehttp://mysite.freeserve.com/root/spFormatOutputBufferBut not by any simple query.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
mnttr
Starting Member
9 Posts |
Posted - 2002-09-10 : 00:38:32
|
| nr: thank you!but the procedure @buffer has no returnwhy? |
|
|
|
|
|
|
replace the objects into erroemessage