Can we Call a Stored procedure inside a function ? .. I saw so many posts saying that it is not possible to call a SP inside a function... ? I dont know, what is the reason ..? can Any one please help me on the reason. I had just seen a post saying that it is possible to call SP's in functions.. stating that only Extended SP can be used not user defined SP's. Why is it so only Extended SPs..? Thanks in advance, Vishnu Vaddi.