Hi,
is there a way to debug user defined functions in SQL server 2000?
The T-SQL de* in VB6 shows only stored procedures.
Thanks a lot for any help
Rainer Kroos
by Rainer Kroo » Thu, 15 Feb 2001 23:07:52
Rainer Kroos
by Tibor Karasz » Fri, 16 Feb 2001 00:14:41
Can't you create a (dummy) proc that calls the function?
I believe that this will step into the function code (not sure, though).
--
Tibor Karaszi, SQL Server MVP
FAQ from Neil at: http://www.veryComputer.com/
Please reply to the newsgroup only, not by email.
Quote:> Hi,
> is there a way to debug user defined functions in SQL server 2000?
> The T-SQL de* in VB6 shows only stored procedures.
> Thanks a lot for any help
> Rainer Kroos
by Rainer Kroo » Fri, 16 Feb 2001 16:22:33
Rainer Kroos
> Can't you create a (dummy) proc that calls the function?
> I believe that this will step into the function code (not sure, though).
> --
> Tibor Karaszi, SQL Server MVP
> FAQ from Neil at: http://www.veryComputer.com/
> Please reply to the newsgroup only, not by email.
> > Hi,
> > is there a way to debug user defined functions in SQL server 2000?
> > The T-SQL de* in VB6 shows only stored procedures.
> > Thanks a lot for any help
> > Rainer Kroos
by Gert E.R. Draper » Sat, 17 Feb 2001 16:36:31
Quote:> Hi Tibor,
> thanks for your answer.
> I copied the function code into a stored procedure, which I can debug.
> I think there is NO WAY to debug functions directly until now.
> Rainer Kroos
> "Tibor Karaszi"
> > Can't you create a (dummy) proc that calls the function?
> > I believe that this will step into the function code (not sure, though).
> > --
> > Tibor Karaszi, SQL Server MVP
> > FAQ from Neil at: http://www.veryComputer.com/
> > Please reply to the newsgroup only, not by email.
> > > Hi,
> > > is there a way to debug user defined functions in SQL server 2000?
> > > The T-SQL de* in VB6 shows only stored procedures.
> > > Thanks a lot for any help
> > > Rainer Kroos
1. how to debug user defined function
How can i debug an user defined function (sql 2000)?
I want to debug, for example, the ISOweek function from the books online.
I have tried it with the print statement but an error occurs.
--
Computer Technology Systems B.V.
Scherpenzeel GLD, The Netherlands
http://www.cts-bv.nl
2. Novell releasing PostgreSQL for NetWare.
3. How to debug User Defined Function?
5. call a user defined function from another user-defined function
6. BDE - Local Share - True or False
7. How to debug user-defined function in Sql 2K?
8. HELLLLLLLP!!!!!!!! Urgent: ADO bug
9. Built in function =user define function
10. Instrinsic function in User-defined function
11. Mixed case function or How to create user defined function
12. return datediff function from user defined function.
13. scalar user-defined function require the function to be owner qualified