SSRS Report Builder Runs Procedure that I cannot find in SSMS

Question

I have a report that calls a stored procedure name sp_rptPoolAndHottubSchedule, when I execute the procedure from report builder it runs with no problems. When I try and locate this procedure inside SSMS using the GUI or the SYS objects it is no were to be found.

What am I doing wrong? It seems like a simple thing.

Answer 1

• or SSMS and SSRS Report Builder run under different credentials

• or following statement was executed:

SQL:

DENY VIEW DEFINITION ON [sp_rptPoolAndHottubSchedule] TO YourAccout    

The existence of the object can be checked via:

-- null means that object not exists
SELECT object_id ('sp_rptPoolAndHottubSchedule')