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.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Function Execution Tracking

Author  Topic 

sqldba20
Posting Yak Master

183 Posts

Posted - 2008-05-07 : 15:54:33
In our stored procedure tracking world, For every stored procedure which is called I call a log entry SP which logs the user and the parameters passed by the user in a table to track who executed the SP and at what time. Can I do the similar thing in a FUNCTION? I tried doing a insert into table name and also calling SP within function but it failed. Is there a limitation ? If so, anybody with a workaround on how can function execution tracking be handled?



Thanks !
   

- Advertisement -