is there anyway to raise a warning from a UDF (in sql2000 and/or in SQL2005)

cos RAISERROR isnt callable, but I really want to indicate a non-fatal warning to be passed back to the client (C++ code)

You are limited to a single output either way dealing with a scalar or table valued function. The only way you could pass back a message of some sort would be to overwrite the scalar return value or add a column to your table return. Neither of those sound particulary appealing but you have few options.|||In SQL Server 2005, you could replace the TSQL UDF with CLR UDF and raise exception in your CLR code. But this is not a pretty implementation and depending on the TSQL code you will get worse performance. So best is to modify the UDF to a SP or just check for absence of row or special value like NULL.

IS THERE ANY TOOL

Is there any tool like Enterprise Manager to help me create databases , tables ... with MSDE?
If there isn't how can i create these objects?
Perhaps using OSQL Command?
Thank you
George
> Is there any tool like Enterprise Manager to help me create databases
> , tables ... with MSDE? If there isn't how can i create these objects?
> Perhaps using OSQL Command?
A good list here:
http://www.microsoft.com/sql/msde/partners/default.asp
I strongly recommend our tool : myLittleAdmin
(http://www.mylittletools.net/mla_sql)
Sincerely
el.c.
// myLittleTools.net : leading provider of web-based applications.
// myLittleAdmin : online MS SQL manager
// http://www.mylittletools.net
// webmaster@.mylittletools.net
|||I use SQL Server Web Data Administrator (free stuff), and
it is really cool!
To help you, I will show were to find the software in the
correct order of installation:
..Microsoft .NET Framework Version 1.1
Redistributable Package
http://www.microsoft.com/downloads/details.aspx?
FamilyID=262d25e3-f589-4842-8157-
034d1e7cf3a3&displaylang=en
..Microsoft .NET Framework SDK Version 1.1
http://www.microsoft.com/downloads/details.aspx?
FamilyID=9b3a2ca6-3647-4070-9f41-
a333c6b9181d&displaylang=en
..ASP.NET Cassini Sample Web Server
http://asp.net/Projects/Cassini/Download/Default.aspx?
tabindex=0&tabid=1
..Microsoft SQL Web Data Administrator
http://www.microsoft.com/downloads/details.aspx?
FamilyId=C039A798-C57A-419E-ACBC-
2A332CB7F959&displaylang=en
Good luck!
Aldrin
PS INSTALL SOFTWARE PACKAGES IN THIS ORDER!
[color=darkblue]
>--Original Message--
create databases[color=darkblue]
create these objects?
>A good list here:
>http://www.microsoft.com/sql/msde/partners/default.asp
>I strongly recommend our tool : myLittleAdmin
>(http://www.mylittletools.net/mla_sql)
>Sincerely
>el.c.
>--
>// myLittleTools.net : leading provider of web-based
applications.
>// myLittleAdmin : online MS SQL manager
>// http://www.mylittletools.net
>// webmaster@.mylittletools.net
>
>.
>
|||The Developer edition of SQL Server is available for $49 from
Microsoft, which has all of the client tools (SEM, QA, Profiler,
etc.), which you can install independently of the server.
--mary
On Tue, 13 Apr 2004 02:51:03 -0700, GEORGE
<anonymous@.discussions.microsoft.com> wrote:

>Is there any tool like Enterprise Manager to help me create databases , tables ... with MSDE?
>If there isn't how can i create these objects?
>Perhaps using OSQL Command?
>Thank you
>George