Debugging User Defined Functions 1

[pramsam1]

Hi All:
I am new to SQL server. I have got the SQL Server 2000 debugger working for Stored procedures but when I right click on a User Defined Function from the Object Browser in the SQL Query Analyzer, the "Debug" is disabled. Does this mean functions cannot be debugged in SQL server 2000 ?

Thanks in advance.

 

[vongrunt]

IIRC ror some reason this option is disabled but UDF debugging capability exists. Just call it from a stored procedure, debug that sproc then do "Step Into" thing on a line containing UDF call.

------
[small]<this is sig>
select stuff(stuff(replicate('<P> <B> ', 14), 109, 0, '<.'), 112, 0, '/')
</this is sig>[/small]

 

[pramsam1]

Excellent. That's great. Thanks.