You can set a breakpoint in the body of the sp_customer_products procedure. When the procedure is executed, execution stops at the breakpoint.
Setting a breakpoint in a stored procedure
In the Source Code window, locate the line with the query:
select product.id,...
Click the green indicator to the left of the line, until it is red.
Repeatedly clicking the indicator toggles its status.
