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 - 2003-09-01 : 07:47:57
|
| DeveloperSufferingFromLackOfDBA writes "I would like to raise a user-defined error in a user-defined function. Enterprise Mgr is not letting me do this. Is this by design, or is it that i am not invoking RAISERROR properly?The pertinent part of the the function code is this:IF (@DataWarehouseBatchID IS NULL) RAISERROR ('TICKETTOGO.DATALAYER.ERROR_NO_OPEN_DATAWAREHOUSE_BATCH', 16, 1) WITH NOWAITBooks online doesn't seem to address using this method from within a UDF.Many thanks,~rachel" |
|
|
Lavos
Posting Yak Master
200 Posts |
Posted - 2003-09-01 : 08:30:30
|
| It's intentional. Sql Server is a little funny with how and when functions/expressions are evaluated, so little things like most builtin non-deterministic functions or stored procs not being callable are put in place to keep the really strange results to a minimum.----------------------"O Theos mou! Echo ten labrida en te mou kephale!""Where theres a will, theres a kludge." - Ken Henderson |
 |
|
|
|
|
|
Use of RAISERROR in a UDF