In that past I see this for 2 reasons

1 - "SET" option differ in SSMS than the default connection to the server i.e. ARITHMETIC ABORT (check server setting and your query options within SSMS)

2 - If you are debugging the SP and provide local variables then I have also seen a different execution plan selected.