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 |
|
sqlfresher2k7
Aged Yak Warrior
623 Posts |
 Posted - 2009-04-20 : 15:49:54
|
| [code]I am using below query SET @errmsg = 'Error while loading student table' + case @SQLVersion when 0 then '' else error_message() endWhen executed i got below errorServer: Msg 195, Level 15, State 10, Line 264'error_message' is not a recognized function name.[/code] |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Lamprey
Master Smack Fu Yak Hacker
4614 Posts |
Posted - 2009-04-20 : 15:54:06
|
| What Tara said. Unless you have a user defined function named error_message. Then I think you need to prefix it with the owner, for example: dbo.error_message(). |
 |
|
|
sqlfresher2k7
Aged Yak Warrior
623 Posts |
Posted - 2009-04-20 : 15:57:21
|
| It's working fine in 2005 when trying to execute the same in 2000 got the error. |
|
|
|
sqlfresher2k7
Aged Yak Warrior
623 Posts |
Posted - 2009-04-20 : 15:59:52
|
| What is the function which i can use instead of ERROR_MESSAGE in sql 2000.. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
sqlfresher2k7
Aged Yak Warrior
623 Posts |
Posted - 2009-04-20 : 21:37:24
|
| I got it.Thanks for your help. |
|
|
|
|
|
|
Error