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 - 2002-02-24 : 21:43:26
|
| Ravikumar Reddy P writes "How can i trap errors in User Defined Functions in SQL Server2000" |
|
|
rrb
SQLTeam Poet Laureate
1479 Posts |
Posted - 2002-02-26 : 01:49:11
|
quote:
Ravikumar Reddy P writes "How can i trap errors in User Defined Functions in SQL Server2000"
What I do is to take the function code out, and make a stored procedure - or just run it in Query Analyser. That way you can use print as usual.If you're not sure what I mean, let me know. - Or even better still, post your function...Edited by - rrb on 02/26/2002 01:50:17 |
 |
|
|
Nazim
A custom title
1408 Posts |
Posted - 2002-02-26 : 02:07:29
|
| you can use @@ERROR and Raiseerror .Check for both in BOL.-------------------------------------------------------------- |
|
|
|
|
|
|
SQL Server2000