How to check a log of stored procedure calls?

Question

Is there some type of logging in SQL Server (or some way to enable simple logging) that would allow me to check if a stored procedure was called, when it was called, and what parameters were passed and returned? I have seen some addon scripts for this but wasn't sure if this was built into SQL Server?

Answer 1

It isn't built in

You need to set up a profiler trace or add code to your stored procedures to log