Home Forums SQL Server 2005 T-SQL (SS2K5) Calling a stored procedure from within a function RE: Calling a stored procedure from within a function

  • The error message is pretty explicit.  You cannot do that.

    If you want to make call to another stored procedure, change your function to be a stored procedure and then you can make the call OR if you do need a function (calling from within a select/DML statement could be one of the reasons for needing the function), then create another function that can be called within this function body.