Your stored procedure was executing as you didn't specify any parameters in that sp...
Please refer Luis post...
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/